p2p.wrox.com Forums

p2p.wrox.com Forums (http://p2p.wrox.com/index.php)
-   BOOK: ASP.NET Website Programming Problem-Design-Solution (http://p2p.wrox.com/forumdisplay.php?f=23)
-   -   Slash Sign "\" in Server Name??? (http://p2p.wrox.com/showthread.php?t=4839)

omermalik October 10th, 2003 01:59 PM

Slash Sign "\" in Server Name???
 
Hi,

I am new to .net stuff. Pardon me from asking such a begining question. In the following line what does CHARUL\NetSDK mean?

<ConnectionString>server=CHARUL\NetSDK;database=ThePhile;uid=sa;pwd=;</ConnectionString>

Server name with slash making me confuse.

Thanks for you help.
Omer

Imar October 10th, 2003 05:14 PM

Hi there,

Before SQL Server 2000, you could only install 1 SQL Server on one physical server. You would connect to that machine using the network name of the physical server. As of version 2000, you can install multiple versions (of SQL 2000) at the same time.

To distinguish between the installed versions, the concept of a Named Instance was introduced. The naming of the installations has the format of Servername\InstanceName. So, in your example, Charul is the name of the server, and NetSDK is the name of the SQL Server instance (most likely a MSDE installation). This way, the .NET SDK installation can safely install a new version of SQL Server, without the risk of corrupting any other SQL Server instance you may have had.

HtH,

Imar


---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.


All times are GMT -4. The time now is 09:54 PM.

Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.