Sql Server
-
Hello again! I'm rather new to what SQL means and does (many new "stored procedures"-words for me lately). So, just the other day i ran into a problem. I designed a program which connects to a SQL Server 2000 Database. And it works just fine on my computer. Still, one of my friends wanted to test the application. I gave him the database files and registered them with SQL Server 2000 (attached to server). He also had VC# Express Edition installed (i think this is the cause and an important clue). When running the .exe, while trying to connect to the databases, he receives an error message which says that there is no connection available for SQL SERVER 2005: An error has occured while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server( :omg: :confused: ). Then, i tried the other way around. I gave him the code of my application, made him run it... and... another error: Cannot open database requested in login 'Consulting'. Login fails. Login failed for user 'GABRIELA\gabi'. I understand that there are users... and i can't synchronize them... but, how do i allow my database to be accesed on any computer with SQL Server 2000 installed on it? the connection string in the program is: Thanks a lot in advance, Catalin David.
-
Hello again! I'm rather new to what SQL means and does (many new "stored procedures"-words for me lately). So, just the other day i ran into a problem. I designed a program which connects to a SQL Server 2000 Database. And it works just fine on my computer. Still, one of my friends wanted to test the application. I gave him the database files and registered them with SQL Server 2000 (attached to server). He also had VC# Express Edition installed (i think this is the cause and an important clue). When running the .exe, while trying to connect to the databases, he receives an error message which says that there is no connection available for SQL SERVER 2005: An error has occured while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server( :omg: :confused: ). Then, i tried the other way around. I gave him the code of my application, made him run it... and... another error: Cannot open database requested in login 'Consulting'. Login fails. Login failed for user 'GABRIELA\gabi'. I understand that there are users... and i can't synchronize them... but, how do i allow my database to be accesed on any computer with SQL Server 2000 installed on it? the connection string in the program is: Thanks a lot in advance, Catalin David.
-
i am using sql 2000. my friend has sql 2000 installed. the problem is that (local) points to sql 2005. and i think that is because of vc# express edition which connects mainly to sql 2005. but i want sql 2000. sorry for the confusion.
Okay then yes, the express edition is whats causing the problem. Id assume he probably installed it when installing Visual Studio 2k5. I actually ran into this problem a few months back, and the solution for me was to uninstall visual studio completely, and reinstall and make sure not to install vc express (custom install if i recall correctly). Id assume you were already on this path so i'm not sure how much help im providing but lmk if you still are pondering a decision. Nathan Lindley
-
Okay then yes, the express edition is whats causing the problem. Id assume he probably installed it when installing Visual Studio 2k5. I actually ran into this problem a few months back, and the solution for me was to uninstall visual studio completely, and reinstall and make sure not to install vc express (custom install if i recall correctly). Id assume you were already on this path so i'm not sure how much help im providing but lmk if you still are pondering a decision. Nathan Lindley
-
oki... will try this. again. just got visual studio 2005 (complete, not express) ... so... will install that, i hope. wish me luck, fingers crossed! thanks a lot!
-
completely means anything else than start->control panel->add/remove programs-> uninstall visual c# express edition?
The reason i wrote that was because, i cant for the life of me think of it now tho, I think you have to clear some registry values. Just try the uninstall via the control panel and if it doesn't work check out this blog: http://blogs.msdn.com/astebner/articles/574618.aspx When I had your problem this blog was a life saver. Good luck. Nathan Lindley
-
Hello again! I'm rather new to what SQL means and does (many new "stored procedures"-words for me lately). So, just the other day i ran into a problem. I designed a program which connects to a SQL Server 2000 Database. And it works just fine on my computer. Still, one of my friends wanted to test the application. I gave him the database files and registered them with SQL Server 2000 (attached to server). He also had VC# Express Edition installed (i think this is the cause and an important clue). When running the .exe, while trying to connect to the databases, he receives an error message which says that there is no connection available for SQL SERVER 2005: An error has occured while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server( :omg: :confused: ). Then, i tried the other way around. I gave him the code of my application, made him run it... and... another error: Cannot open database requested in login 'Consulting'. Login fails. Login failed for user 'GABRIELA\gabi'. I understand that there are users... and i can't synchronize them... but, how do i allow my database to be accesed on any computer with SQL Server 2000 installed on it? the connection string in the program is: Thanks a lot in advance, Catalin David.
Why not attach the db to the instance of SQL 2005? I suspect whether you are using C# Express or Professional will not makes all that much difference.
Learning is not a spectator sport. - D. Blocher
-
Why not attach the db to the instance of SQL 2005? I suspect whether you are using C# Express or Professional will not makes all that much difference.
Learning is not a spectator sport. - D. Blocher
Sorry for the late answer, but was not in town for a day. The thing is that my friend doesn't have an instance of sql 2005 installed on the system. plus, i think the connection string would change (sql 2005 express accepts only files to be accessed as far as i remember; i've worked only a little with 2005 because i had some conflicts on my pc so i had to reinstall all the system and...). Thanks a lot. If professional doesn't solve it, i'm gonna take all the database to 2005. Thanks again, Catalin David.