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 |
|
shapper
Constraint Violating Yak Guru
450 Posts |
 Posted - 2008-10-09 : 07:36:04
|
| Hello,I had VS 2008 working with SQL 2005. Yesterday, I installed SQL 2008.Now I am not able to create tables in a database from VS 2008.I am able to create the connection but when I run the script I get:"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: SQL Network Interfaces, error: 26 - Error Locating Server / Instance Specified"I always use the following procedure to configure my SQL server:http://www.datamasker.com/SSE2005_NetworkCfg.htmWith SQL 2008 I don't have a Surface Area Configuration Utility. Well, at least on my shortcuts ...So I am not able to follow the first step:http://www.datamasker.com/SSE2005_SAC.htmIs this the problem?Could someone, please, help me out?Thanks,Miguel |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2008-10-09 : 07:46:20
|
Change your connection to your new database instance.www.connectionstrings.com
E 12°55'05.63"N 56°04'39.26" |
 |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2008-10-09 : 07:55:13
|
| Maybe it's not the Connection String...Express version - i'm not sure.But SQL Server 2008:Start Sql Server Configuration Manager and there under Network Configuration you will find Protocols to enable/disable.EDIT: Also see here: http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=112127WebfredPlanning replaces chance by mistake |
|
|
|
shapper
Constraint Violating Yak Guru
450 Posts |
Posted - 2008-10-09 : 08:30:55
|
| Yes,I have enabled all those protocols: Shared Memory, Named Pipes and TCP/IP. The only one disabled is VIA.And my connection string was automatically created on my Web.Config file when I created a LinqToSQL dbml file:<add name="MyAppConnectionString" connectionString="Data Source=SPH;Initial Catalog=MyApp;Integrated Security=True" providerName="System.Data.SqlClient" /> This seems ok. |
|
|
|
afrika
Master Smack Fu Yak Hacker
2706 Posts |
Posted - 2008-10-09 : 08:31:28
|
| It has nothing to do with your connection string. Also surface area configuration manager has been removed in 2008.Question: are you connecting locally or remotely ? Sounds to me as though its a remote connection.Visual studio creates your connection string, for you so you dont have to create one, just click add db in the database panel on the top right hand corner, inbetween your solutions panel. |
|
|
|
|
|
|
|
|
Remote Connections