How to create server alias

Can anyone descrive in principle how a Web server alias is actually set
up? How do you get a server alias to point to a particular server with
a particular IP address within a large organisation? The outcome being
that when a user types the alias url into the address bar, the correct
page appears in the browser window
Hi
Does it somehow relate to SQL Server?
<simonaj30@.yahoo.co.uk> wrote in message
news:1162895112.082029.220030@.i42g2000cwa.googlegr oups.com...
> Can anyone descrive in principle how a Web server alias is actually set
> up? How do you get a server alias to point to a particular server with
> a particular IP address within a large organisation? The outcome being
> that when a user types the alias url into the address bar, the correct
> page appears in the browser window
>
|||I would think so, as we use it in our organisation
Uri Dimant wrote:[vbcol=seagreen]
> Hi
> Does it somehow relate to SQL Server?
>
> <simonaj30@.yahoo.co.uk> wrote in message
> news:1162895112.082029.220030@.i42g2000cwa.googlegr oups.com...
|||Well, If I understood you , take a look at Client Network Utility to add a
new alias to the server
<simonaj30@.yahoo.co.uk> wrote in message
news:1162896637.485781.85960@.m73g2000cwd.googlegro ups.com...
>I would think so, as we use it in our organisation
> Uri Dimant wrote:
>
|||You right Uri...
Post this in question in Internet Information service(IIS) group. This is
done through IIS configuration.
This is SQL Server group.
vinu
<simonaj30@.yahoo.co.uk> wrote in message
news:1162896637.485781.85960@.m73g2000cwd.googlegro ups.com...
>I would think so, as we use it in our organisation
> Uri Dimant wrote:
>
|||ok, many thanks
Uri Dimant wrote:[vbcol=seagreen]
> Well, If I understood you , take a look at Client Network Utility to add a
> new alias to the server
>
> <simonaj30@.yahoo.co.uk> wrote in message
> news:1162896637.485781.85960@.m73g2000cwd.googlegro ups.com...

How to create server alias

Can anyone descrive in principle how a Web server alias is actually set
up? How do you get a server alias to point to a particular server with
a particular IP address within a large organisation? The outcome being
that when a user types the alias url into the address bar, the correct
page appears in the browser windowHi
Does it somehow relate to SQL Server?
<simonaj30@.yahoo.co.uk> wrote in message
news:1162895112.082029.220030@.i42g2000cwa.googlegroups.com...
> Can anyone descrive in principle how a Web server alias is actually set
> up? How do you get a server alias to point to a particular server with
> a particular IP address within a large organisation? The outcome being
> that when a user types the alias url into the address bar, the correct
> page appears in the browser window
>|||I would think so, as we use it in our organisation
Uri Dimant wrote:[vbcol=seagreen]
> Hi
> Does it somehow relate to SQL Server?
>
> <simonaj30@.yahoo.co.uk> wrote in message
> news:1162895112.082029.220030@.i42g2000cwa.googlegroups.com...|||Well, If I understood you , take a look at Client Network Utility to add a
new alias to the server
<simonaj30@.yahoo.co.uk> wrote in message
news:1162896637.485781.85960@.m73g2000cwd.googlegroups.com...
>I would think so, as we use it in our organisation
> Uri Dimant wrote:
>|||You right Uri...
Post this in question in Internet Information service(IIS) group. This is
done through IIS configuration.
This is SQL Server group.
vinu
<simonaj30@.yahoo.co.uk> wrote in message
news:1162896637.485781.85960@.m73g2000cwd.googlegroups.com...
>I would think so, as we use it in our organisation
> Uri Dimant wrote:
>|||ok, many thanks
Uri Dimant wrote:[vbcol=seagreen]
> Well, If I understood you , take a look at Client Network Utility to add
a
> new alias to the server
>
> <simonaj30@.yahoo.co.uk> wrote in message
> news:1162896637.485781.85960@.m73g2000cwd.googlegroups.com...

How to create a Virtual Directory that uses instance name

Hi,
I installed Reporting Services 2005 as an instance MYMACHINE\RS2005. If I do
this, the regular setup creates a Virtual Directory called
http://MYMACHINE/ReportServer$RS2005/
But if I wanted to create a similar virtual directory (say
http://MYMACHINE/TestServer$RS2005) using Reporting Services Configuration
tool, it errors out saying the virtual directory name is invalid (I just type
in TestServer$RS2005 in the virtual directory name)
How can I accomplish this?
Any help is greatly appreciated.
Thanks.Also,
I just found documentation on MSDN that said that the tool will
automatically add the instance name, but when I use the tool, it just creates
a Virtual Directory called TestServer.
"Raghu" wrote:
> Hi,
> I installed Reporting Services 2005 as an instance MYMACHINE\RS2005. If I do
> this, the regular setup creates a Virtual Directory called
> http://MYMACHINE/ReportServer$RS2005/
> But if I wanted to create a similar virtual directory (say
> http://MYMACHINE/TestServer$RS2005) using Reporting Services Configuration
> tool, it errors out saying the virtual directory name is invalid (I just type
> in TestServer$RS2005 in the virtual directory name)
> How can I accomplish this?
> Any help is greatly appreciated.
> Thanks.

How to Create a setup file to install Sql Server Database

Hi All,
I'am looking for a software (Installer) to create a setup file to install a SQL Server Database just like the one in theReports Starter Kit, when you install it a dialog will guide you to instaal the database thats what i'am looking for.
Anybody knows how can i do that or is there a software that can help me doing that.
Best Regards.
Wafi MohtasebIf you find it let me know.|||

I am not sure if it is possible because Microsoft tried it with AdventureWorks 2000 using InstallShield but it did not work. Now to what works the old AdventureWorks 2000 is an MSI file that creates an application with Instawdb.sql file inside the application open it with note pad and execute in Query Analyzer and you have the database. So you need Windows Installer redistributable and a detailed read me. Hope this helps.

How to create a new instance with SQL 2005

Someone else installed SQL 2005 on the server and I am now trying to create
a new instance.
The documention seems to be pointing me to the setup CD to do this. However,
the only
options to install are the client tools and samples. It never mentions
anything about creating
a new instance.
When going through the "Control Panel" and clicking on the "Change" button
for SQL 2005
it does have a link to click on called "To install a new component, click
here". But all this
link does is start the same setup again, which doesn't mention anything
about creating a new
instance.
The version of SQL is 2005 standard. the CD has two folders, "Servers" and
"Tools".
Each have a setup.exe in them, but both seem to be the same exact program.
Does anyone know how to do this?
Thanks
JeffYes you would use the CD. Disk 1 (or the Server Folder)
should have a SQLRun.msi that you would execute from the
Setup Directory.
Select SQL Server Database Services from the setup screen
after the prerequisite checks run. An instance name screen
comes up a screen or two later - I think after the Feature
selection screen. From there you select Named Instance.
-Sue
On Mon, 2 Oct 2006 16:22:30 -0500, "JD" <summer79@.gte.net>
wrote:

>Someone else installed SQL 2005 on the server and I am now trying to create
>a new instance.
>The documention seems to be pointing me to the setup CD to do this. However
,
>the only
>options to install are the client tools and samples. It never mentions
>anything about creating
>a new instance.
>When going through the "Control Panel" and clicking on the "Change" button
>for SQL 2005
>it does have a link to click on called "To install a new component, click
>here". But all this
>link does is start the same setup again, which doesn't mention anything
>about creating a new
>instance.
>The version of SQL is 2005 standard. the CD has two folders, "Servers" and
>"Tools".
>Each have a setup.exe in them, but both seem to be the same exact program.
>Does anyone know how to do this?
>Thanks
>Jeff
>

How to create a new instance with SQL 2005

Someone else installed SQL 2005 on the server and I am now trying to create
a new instance.
The documention seems to be pointing me to the setup CD to do this. However,
the only
options to install are the client tools and samples. It never mentions
anything about creating
a new instance.
When going through the "Control Panel" and clicking on the "Change" button
for SQL 2005
it does have a link to click on called "To install a new component, click
here". But all this
link does is start the same setup again, which doesn't mention anything
about creating a new
instance.
The version of SQL is 2005 standard. the CD has two folders, "Servers" and
"Tools".
Each have a setup.exe in them, but both seem to be the same exact program.
Does anyone know how to do this?
Thanks
Jeff
Yes you would use the CD. Disk 1 (or the Server Folder)
should have a SQLRun.msi that you would execute from the
Setup Directory.
Select SQL Server Database Services from the setup screen
after the prerequisite checks run. An instance name screen
comes up a screen or two later - I think after the Feature
selection screen. From there you select Named Instance.
-Sue
On Mon, 2 Oct 2006 16:22:30 -0500, "JD" <summer79@.gte.net>
wrote:

>Someone else installed SQL 2005 on the server and I am now trying to create
>a new instance.
>The documention seems to be pointing me to the setup CD to do this. However,
>the only
>options to install are the client tools and samples. It never mentions
>anything about creating
>a new instance.
>When going through the "Control Panel" and clicking on the "Change" button
>for SQL 2005
>it does have a link to click on called "To install a new component, click
>here". But all this
>link does is start the same setup again, which doesn't mention anything
>about creating a new
>instance.
>The version of SQL is 2005 standard. the CD has two folders, "Servers" and
>"Tools".
>Each have a setup.exe in them, but both seem to be the same exact program.
>Does anyone know how to do this?
>Thanks
>Jeff
>

How to create a new instance with SQL 2005

Someone else installed SQL 2005 on the server and I am now trying to create
a new instance.
The documention seems to be pointing me to the setup CD to do this. However,
the only
options to install are the client tools and samples. It never mentions
anything about creating
a new instance.
When going through the "Control Panel" and clicking on the "Change" button
for SQL 2005
it does have a link to click on called "To install a new component, click
here". But all this
link does is start the same setup again, which doesn't mention anything
about creating a new
instance.
The version of SQL is 2005 standard. the CD has two folders, "Servers" and
"Tools".
Each have a setup.exe in them, but both seem to be the same exact program.
Does anyone know how to do this?
Thanks
JeffYes you would use the CD. Disk 1 (or the Server Folder)
should have a SQLRun.msi that you would execute from the
Setup Directory.
Select SQL Server Database Services from the setup screen
after the prerequisite checks run. An instance name screen
comes up a screen or two later - I think after the Feature
selection screen. From there you select Named Instance.
-Sue
On Mon, 2 Oct 2006 16:22:30 -0500, "JD" <summer79@.gte.net>
wrote:
>Someone else installed SQL 2005 on the server and I am now trying to create
>a new instance.
>The documention seems to be pointing me to the setup CD to do this. However,
>the only
>options to install are the client tools and samples. It never mentions
>anything about creating
>a new instance.
>When going through the "Control Panel" and clicking on the "Change" button
>for SQL 2005
>it does have a link to click on called "To install a new component, click
>here". But all this
>link does is start the same setup again, which doesn't mention anything
>about creating a new
>instance.
>The version of SQL is 2005 standard. the CD has two folders, "Servers" and
>"Tools".
>Each have a setup.exe in them, but both seem to be the same exact program.
>Does anyone know how to do this?
>Thanks
>Jeff
>

How to copy DSN from one server to another?

I need to setup identical System DSN ODBC connections on multiple servers...
is there a way to easily migrate the System DSNs from one server to another?Generally, file DSNs are used if needing to move DSNs around
to other machines (or ideally use DSN-Less connections). But
I know some people have copied system DSNs by exporting the
following registry key:
HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI
-Sue
On Tue, 11 Jan 2005 12:03:04 -0800, Ron Niederer <Ron
Niederer@.discussions.microsoft.com> wrote:
[vbcol=seagreen]
>I need to setup identical System DSN ODBC connections on multiple servers..
.
>is there a way to easily migrate the System DSNs from one server to another?[/vbcol
]|||Ron,
Please try out our free ODBC manager (www.sqledit.com/odbc) for this
purpose.
RN> I need to setup identical System DSN ODBC connections on multiple
RN> servers... is there a way to easily migrate the System DSNs from one
server to
RN> another?
Igor Shekalev, http://www.sqledit.com, powerful database tools

How to copy DSN from one server to another?

I need to setup identical System DSN ODBC connections on multiple servers...
is there a way to easily migrate the System DSNs from one server to another?
Generally, file DSNs are used if needing to move DSNs around
to other machines (or ideally use DSN-Less connections). But
I know some people have copied system DSNs by exporting the
following registry key:
HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI
-Sue
On Tue, 11 Jan 2005 12:03:04 -0800, Ron Niederer <Ron
Niederer@.discussions.microsoft.com> wrote:

>I need to setup identical System DSN ODBC connections on multiple servers...
>is there a way to easily migrate the System DSNs from one server to another?
|||Ron,
Please try out our free ODBC manager (www.sqledit.com/odbc) for this
purpose.
RN> I need to setup identical System DSN ODBC connections on multiple
RN> servers... is there a way to easily migrate the System DSNs from one
server to
RN> another?
Igor Shekalev, http://www.sqledit.com, powerful database tools