I've created a local .mdf database with Visual Studio 2010 and did a couple of modifications to it. Now I want to edit it in IIS Manager. However, I cannot access it neither by connection string, nor by direct specification.
First. I copied a connection string from Visual Studio 2010 properties window for the DB, it was like
Data Source=.\SQLEXPRESS;AttachDbFilename=o:\...\MyDB.mdf;Integrated Security=True;User Instance=True. I went to IIS Manager -> Connection Strings -> Add -> Custom and pasted it. Then went to IIS Manager -> Database Manager -> MyDB, it opened, but there were no visible contents while I've added several tables.
Second. I used "Add Connection" in Database Manager and specified properties like following:
- Database provider == SQL Server 2008
- Server == localhost
- Database == o:...\MyDB.mdf
- User ID == my_local_user_name
But when I accessed newly created connection, I got the following error:
There was an error while performing this operation. Details:
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)
Same if I set Server field to SQLEXPRESS. Any ideas?
- Windows 7 x64 Ultimate
- Microsoft SQL Server 2008 x64
- Visual Studio 2010 Professional SP1
- IIS Manager x64