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.

 All Forums
 General SQL Server Forums
 Database Design and Application Architecture
 SQL server 2008 restore error

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 Server
I 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.
Go to Top of Page
   

- Advertisement -