MikeyLDS Posted August 27, 2004 Posted August 27, 2004 Hi guys ... this may make me look clueless :confused: I'm trying to use the Server Explorer to connect to a sample database (Northwind). Then my own once I have got to grips with that one. I've changed the "Provider" to: Microsoft OLE DB Provider for SQL Server as suggested by a training manual. When I click on next and goto the connection tab I get completely lost! I'm assuming that it is essential to set-up a server name but where on earth do I get one of those. Can I not simply just to step 3 and key in the info for the "Northwind" sample database? Many thanks, Mikey Quote Thanks Guys ... Your help is much appreciated. Bye the way, I love to chat online via messenger and peeps seem to ask me alot my my handle as well. If you wanna then please add energizerbunny101@hotmail.com to your instant messenger.
Administrators PlausiblyDamp Posted August 27, 2004 Administrators Posted August 27, 2004 What is the name of the server runnning SQL Server? Just enter that - if it is you local computer then either put it's name or just type (local) Quote Posting Guidelines FAQ Post Formatting Intellectuals solve problems; geniuses prevent them. -- Albert Einstein
MikeyLDS Posted August 27, 2004 Author Posted August 27, 2004 What is the name of the server runnning SQL Server? Just enter that - if it is you local computer then either put it's name or just type (local) I'm still getting an error after entering "(local)": [DBNETLIB][Connection Open(Connect()).]SQL Server does not exist or access denied. Quote Thanks Guys ... Your help is much appreciated. Bye the way, I love to chat online via messenger and peeps seem to ask me alot my my handle as well. If you wanna then please add energizerbunny101@hotmail.com to your instant messenger.
Administrators PlausiblyDamp Posted August 27, 2004 Administrators Posted August 27, 2004 Do you have SQL server running on the machine? If so what authentication mode are you using? Quote Posting Guidelines FAQ Post Formatting Intellectuals solve problems; geniuses prevent them. -- Albert Einstein
MikeyLDS Posted August 27, 2004 Author Posted August 27, 2004 I'm not sure what you mean by authentication mode. I have a little success by playing around ... I can connect to databases on my PC by using the Microsoft Jet provider. If I wanted to connect other pc's to it via LAN or over the internet in the future would all my programming goto waste or is it just a case for changing a few connection details? Quote Thanks Guys ... Your help is much appreciated. Bye the way, I love to chat online via messenger and peeps seem to ask me alot my my handle as well. If you wanna then please add energizerbunny101@hotmail.com to your instant messenger.
Arch4ngel Posted August 27, 2004 Posted August 27, 2004 If your SQL-Server is set to Windows Authentication then... the user who want to access it won't have any problem as long as he has received permission. But there's also the SQL Authentication. Which means user id and password. The admin account is named "sa" (system admin). You can create more under the Security folder inside Enterprise manager. Quote "If someone say : "Die mortal !"... don't stay to see if he isn't." - Unknown "Learning to program is like going out with a new girl friend. There's always something that wasn't mentioned in the documentation..." - Me "A drunk girl is like an animal... it scream at everything like a cat and roll in the grass like a dog." - Me after seeing my girlfriend drunk and some of her drunk friend. C# TO VB TRANSLATOR
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.