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 |
|
melbenmartin
Starting Member
2 Posts |
 Posted - 2014-09-22 : 22:35:52
|
| (provider: Named Pipes Provider, error: 40 – Could not open a connection to SQL ServerI restored a backup which i was not created to a new database and if i connect above said issue is coming , if i generate script from restored DB and running without data in another new database and connecting to the same is working .. can you plz tell what will be the exact problem and i found one database level user is there as below in the script.CREATE USER [appointment_bee] WITHOUT LOGIN WITH DEFAULT_SCHEMA=[dbo]kindly let me know whats the problem ..MARTIN ROBERT |
|
|
Lincolnburrows
Yak Posting Veteran
52 Posts |
Posted - 2014-09-24 : 04:47:08
|
| You must ensure Backup copy of database is good or not. As well as enable TCP/IP protocol in order to allow remote connection. |
 |
|
|
|
|
|
SQL server 2008 restore error