Click here to Skip to main content
14,662,524 members
Home » Discussions » Database
   

Database

 
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 
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 
indian143 wrote:
Named Pipes Provider, error: 40 - Could not open a connection to SQL Server

It's nothing to do with the database - your code can't connect to SQL Server.
  • Check the name and instance name in your connection string.
  • Check that SQL Server on server B1 is configured to allow remote connections.
  • If you're using the Express version, check that the SQL Browser service is running on server B1.
  • Using the SQL Server Configuration Manager on server B1, check under "SQL Server Network Configuration" that there is at least one enabled protocol;
  • Using the SQL Server Configuration Manager on the client, check under "SQL Native Client Configuration" (both 64- and 32-bit) that at least one of the server protocols from B1 is enabled;
  • Check any firewalls between the client and the server;




"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer


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 
GeneralRe: Billion rows Pin
jschell14-Mar-18 15:13
Memberjschell14-Mar-18 15:13 

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.