instance name on sql server 2005

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

Other SQL Server Topics (2005)

instance name on sql server 2005

Author

Topic

nastit
Starting Member

5 Posts

Posted - 2008-12-24 : 00:28:22

Dear All,

I want to install wsus server, as WSUS installation guide, I got the step that made me confused. Here is step:

"If you do not wish to use Windows Internal Database, you must provide a SQL Server instance for WSUS to use, by clicking Using an existing database server on this computer and typing the instance name in the box. The instance name should appear as <serverName>\<instanceName>, where serverName is the name of the server and instanceName is the name of the SQL instance. Make your selection, and then click Next"

Generally, if I want to connect database on remote computer ( Database Server), I just type <serverName> without <instanceName>. ( I just use default instance name).

FYI; I have 4 applications that to connect the database server, each applications use different database.

Is it no problem if I install wsus and connect to the database server by typing <serverName> only? or
Should I create new instance name for installing wsus application, and how to do it?

kindly please help me.

Thanks,
ns

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2008-12-24 : 00:33:27

You would use whatever was used in the SQL Server installation. If you don't remember, then list out what services you see that have SQL Server in the name.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

nastit
Starting Member

5 Posts

Posted - 2008-12-24 : 01:07:53

Oh.. you mean should I to let existing sql server 2005 configuration?
I installed it by default, I predicate the instance name is default too.

You mean list of local service on database server.
Below is the lists:

SQL Server (MSSQLSERVER)
SQL Server Active Directory Helper
SQL Server Agent (MSSQLSERVER)
SQL Server Analysis Services (MSSQLSERVER)
SQL Server Browser
SQL Server FullText Search (MSSQLSERVER)
SQL Server Integration Service
SQL Server VSS Writer

I'am sorry, I confused about instance name.

Thanks,
ns

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2008-12-24 : 12:32:57

Yes you've installed the default instance. So you'd just use your hostname to connect to it.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

nastit
Starting Member

5 Posts

Posted - 2008-12-25 : 19:30:06

Thanks Kizer.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources