Click here to Skip to main content
14,546,974 members
   

Database

 
GeneralRe: Mysql database problem Pin
Victor Nijegorodov31-Mar-18 20:56
MemberVictor Nijegorodov31-Mar-18 20:56 
AnswerRe: Mysql database problem Pin
jschell31-Mar-18 7:34
Memberjschell31-Mar-18 7:34 
QuestionSSIS package and package in a SQL server agent Job Pin
VK1927-Mar-18 8:27
MemberVK1927-Mar-18 8:27 
GeneralRe: SSIS package and package in a SQL server agent Job Pin
CHill6027-Mar-18 22:09
mveCHill6027-Mar-18 22:09 
GeneralRe: SSIS package and package in a SQL server agent Job Pin
VK1928-Mar-18 2:06
MemberVK1928-Mar-18 2:06 
GeneralRe: SSIS package and package in a SQL server agent Job Pin
CHill6029-Mar-18 12:27
mveCHill6029-Mar-18 12:27 
AnswerRe: SSIS package and package in a SQL server agent Job Pin
#realJSOP29-Mar-18 8:54
mva#realJSOP29-Mar-18 8:54 
QuestionApplication stopped working after backup and restoring the Database with another name Pin
indian14326-Mar-18 8:55
Memberindian14326-Mar-18 8:55 
Hi,

I have taken a backup of Database A from Server A1 then I restored this Database with name B on Server B1, now the application is working fine with Database A on Server A1 but not working with Database B on Server B1, I have checked the users, I have the users and I have given access to the users when it didn't work I have dropped the User which is connecting from Web application and recreated that user and granted the same permissions it had previously on this Database but still I am not able to use the application.

Here is the error that I am getting:
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)

Any help would be greatly helpful thanks in advance.

Thanks,

Abdul Aleem

"There is already enough hatred in the world lets spread love, compassion and affection."
AnswerRe: Application stopped working after backup and restoring the Database with another name Pin
Richard Deeming26-Mar-18 10:00
mveRichard Deeming26-Mar-18 10:00 
GeneralRe: Application stopped working after backup and restoring the Database with another name Pin
indian14327-Mar-18 6:10
Memberindian14327-Mar-18 6:10 
QuestionSQL server job execution time Pin
VK1922-Mar-18 7:47
MemberVK1922-Mar-18 7:47 
AnswerRe: SQL server job execution time Pin
Victor Nijegorodov22-Mar-18 8:40
MemberVictor Nijegorodov22-Mar-18 8:40 
GeneralRe: SQL server job execution time Pin
VK1922-Mar-18 9:11
MemberVK1922-Mar-18 9:11 
GeneralRe: SQL server job execution time Pin
Victor Nijegorodov22-Mar-18 9:45
MemberVictor Nijegorodov22-Mar-18 9:45 
AnswerRe: SQL server job execution time Pin
David Mujica26-Mar-18 5:55
MemberDavid Mujica26-Mar-18 5:55 
QuestionReplace ids with value Pin
Member 1266749416-Mar-18 8:32
MemberMember 1266749416-Mar-18 8:32 
AnswerRe: Replace ids with value Pin
Eddy Vluggen16-Mar-18 8:54
professionalEddy Vluggen16-Mar-18 8:54 
Rant[REPOST] Replace ids with value Pin
Richard Deeming16-Mar-18 11:42
mveRichard Deeming16-Mar-18 11:42 
QuestionReplace Ids With value Pin
Member 1266749416-Mar-18 8:29
MemberMember 1266749416-Mar-18 8:29 
AnswerRe: Replace Ids With value Pin
Victor Nijegorodov16-Mar-18 9:21
MemberVictor Nijegorodov16-Mar-18 9:21 
QuestionDB2 to SQL conversion Pin
Member 1028121715-Mar-18 4:06
MemberMember 1028121715-Mar-18 4:06 
AnswerRe: DB2 to SQL conversion Pin
Victor Nijegorodov15-Mar-18 5:09
MemberVictor Nijegorodov15-Mar-18 5:09 
AnswerRe: DB2 to SQL conversion Pin
Richard Deeming15-Mar-18 6:41
mveRichard Deeming15-Mar-18 6:41 
QuestionBillion rows Pin
jschell10-Mar-18 10:39
Memberjschell10-Mar-18 10:39 
AnswerRe: Billion rows Pin
Jörgen Andersson10-Mar-18 11:42
professionalJörgen Andersson10-Mar-18 11:42 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.