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 |
|
wan
Starting Member
1 Post |
 Posted - 2010-09-26 : 17:03:57
|
| Dear all,Please help me. I got problem with my sql.I tried to restore my old backup file but still showed same alarm.I already enable remote connection for sql server and sqlserver browser. Database name and SQL servername were key in correctly.Alarm"Cannot connect to the designated database!A network related or instance specific error occured while establishing a connection to sql server.The server was not found or was not accessible.Verify that instance name is correct and that sql server is configured to allow remote connection." Thank You |
|
|
pk_bohra
Master Smack Fu Yak Hacker
1182 Posts |
Posted - 2010-09-27 : 05:33:56
|
| Can you ping the server ?What is the value for below protocols :Named Pipes & TCP/IP . |
 |
|
|
aravindt77
Posting Yak Master
120 Posts |
Posted - 2010-09-27 : 05:41:53
|
| Please restart your sql service |
|
|
|
tosscrosby
Aged Yak Warrior
676 Posts |
Posted - 2010-09-28 : 16:22:41
|
quote:
Originally posted by aravindt77
Please restart your sql service
Maybe as a last resort. Get the info PK requested. Can you connect to the instance at all or just not that database? If you can get the instance to come up, expand the database tab and see what state the database in question is in. I'm willing to bet "loading" even though the restore failed. If you are trying to attach directly to that database, you will not be able to until you do a successful restore or drop/recreate a blank database to replace the offending database.Terry-- You can't be late until you show up. |
|
|
|
|
|
|
Failed to connect to designated SQL server