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 |
|
Stas21
Starting Member
3 Posts |
 Posted - 2009-07-19 : 05:59:25
|
Hi,I'm learning ASP.NET (VS 2008 SP1) and I'm trying to create a database for profiles.I'm new to SQL server(just installed it a few days ago).When I try to access database I get this exception: quote:
A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)
How do I enable it to receive remote connections?I enabled SQL server browser,allowed Named pipes and TCP/IP protocols for my server.And also I allowed the same client protocols.P.S.Membership API with works fine. |
|
|
afrika
Master Smack Fu Yak Hacker
2706 Posts |
Posted - 2009-07-20 : 16:49:32
|
| In 2008, login to management studio and right click on the instance and choose >> facets...then on the top drop down list, choose server configuration... scroll it down to EnableAccessEnabled and change it to true |
 |
|
|
Stas21
Starting Member
3 Posts |
Posted - 2009-07-20 : 17:29:53
|
| I'm sorry,but where do I find management studio?In Start menu I just have SQL Server Configuration Manager,SQL Server Error and Usage Reporting,SQL Server Installation Center and Import and Export Data (32-bit). |
|
|
|
afrika
Master Smack Fu Yak Hacker
2706 Posts |
Posted - 2009-07-21 : 07:48:04
|
| check in add/remove programs in the control panel, if its not there, then download and install it |
|
|
|
Stas21
Starting Member
3 Posts |
Posted - 2009-07-23 : 13:46:17
|
Upgraded my server to Enterprise edition.Added management studio.RemoteAccessEnabled is already true.Now I get this error: quote:
The user instance login flag is not supported on this version of SQL Server. The connection will be closed.
Where do I enable it? |
|
|
|
|
|
|
Allow SQL server 08 express to receive connections