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.
| Author |
Topic |
|
exp2000
Starting Member
5 Posts |
 Posted - 2008-11-29 : 10:59:56
|
| Hi, first let me say that I read 100's of forum postings about this issue and none are helping me resolve this problem. I am trying to connect to named instance of the sql server from asp.net application locally. Database was detached from other machine and was SQLEPRESS instance. I attached it to my machine as non-sqlexpress instance named LT-SANDRA. Following are the facts that might help you help me.Vista Home premium machine with IIS7 and MS SqlServer 2005 and also express edition (both running as LT-SANDRA and LT-SANDRA\SQLEXPRESS).I've put my database under users document folder.Surface area config tool:1. MSSQLSERVER service is running2. Remote connections are set to using both TCP/IP and named pipes3. SQLSERVERAGENT is runnnig4. SQLBrowser service is running Sql Server configuration manager:1. MSSQLSERVER protocols: Shared Memory is enabled, Named pipes is enabled, TCP/IP is enabled, VIA is disabledWindows firewall:1. SQLBrowser.exe is added to windows firewall as exception (not sure if this is needed at all as I don't to access anything remotely)Connection string:Server=LT-SANDRA;Database=dnn49;uid=sa;pwd=password;I can connect to it from management studio and from server explorer in VS2008. I am pulling my hairs out, I don't know what else to look at. Why is this so complicated. Please help me set this up right.Thanks bunch. |
|
|
snSQL
Master Smack Fu Yak Hacker
1837 Posts |
Posted - 2008-11-29 : 11:48:18
|
| What is the code you are using to try to connect, and what is the error you get when you run that code? |
 |
|
|
|
|
|
Error Locating Server/Instance Specified