May 20, 2008 at 7:08 am
hello,
i have one default named instance of sql server 2005 enterprise edition in my PC.
From visual studio i was able to connect to default instance but not to name instance .It is not showing the named instance name.I created an alias name and port number for it in sql server configuration manager.But that also not working,Can anybody guide me to solve this problem
megha,
May 20, 2008 at 8:42 am
Hello,
Since you say "On My PC" I assume that Visual Studio and SQL Server are on the same computer.
In the Configuration Manager for Named Instance under Network Configuration make sure TCP/IP is enabled and under Services make sure that the instance is started. In the SQL Server Log for your instance where the startup entries are make sure the instance is started on the port you specified. In the Configuration manager under Client Configuration , Aliases make sure the correct port is specified
Regards,Yelena Varsha
May 20, 2008 at 8:47 am
Be sure you are connecting to the servername/instancename.
so if your computer is "Bob", and you have a default and named instance of "Sales", you connect to "Bob" to connect to the default and "Bob\Sales" to connect to the named instance.
Are you sure both instances are running? Is the SQL Browser running?
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply