| Author |
Topic |
|
WarrenAyen
Starting Member
5 Posts |
 Posted - 2006-08-21 : 14:11:05
|
| I've never used SQL Server before. I installed VB 2005 Express (I've been working with VB since I was 16), and SQL Server 2005 Express.I installed the server with all the default settings and created a small database to handle customer information (a remake of some Access and Oracle databases I've made before).I'm told, however, each time I try to connect to the database via VB, that SQL Server isn't accepting remote connections...Remote? It's on a local computer. So is VB...what is going on here? Is there a setting I've missed?Warren AyenIBM |
|
|
afrika
Master Smack Fu Yak Hacker
2706 Posts |
Posted - 2006-08-21 : 19:30:26
|
| Paste your connection string herealso see this www.connectionstrings.com |
 |
|
|
WarrenAyen
Starting Member
5 Posts |
Posted - 2006-08-21 : 19:55:28
|
| I can't. I'm using the wizard in VB. It won't even get far enough to make the string - I get the error whenever I try to finish the wizard or test the connection...Warren AyenIBM |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-08-21 : 19:59:49
|
| Is the SQL Server service even started?Tara Kizer |
|
|
|
WarrenAyen
Starting Member
5 Posts |
Posted - 2006-08-21 : 20:33:19
|
| yes, the service is started and I've created a database. I've checked to see that the Service is granted admin logon. I can't see why I'm told that it won't accept a remote connection; I enabled remote connections via TCP/IP on the Surface Area config MMC (wow, I'm learning! hehe)...Warren AyenIBM |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-08-22 : 00:15:10
|
| So you can connect fine via SSMS (Management Studio)?Tara Kizer |
|
|
|
WarrenAyen
Starting Member
5 Posts |
Posted - 2006-08-22 : 02:54:16
|
| Yes, I can connect fine via SSMS. I can create databases, connect to them, change them, everything I want. But VB will not connect. I'm told that it couldn't connect to the datasource and one reason why could be that the default installation doesn't accept remote connections.Like I said before :)...I've set it up to allow remote connections via TCP/IP, so that can't be the issue...Warren AyenIBM |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2006-08-22 : 03:35:54
|
| What about named pipes? If it is a local database, I think named pipes will be used before TCP/IP.Peter LarssonHelsingborg, Sweden |
|
|
|
afrika
Master Smack Fu Yak Hacker
2706 Posts |
Posted - 2006-08-22 : 05:30:12
|
quote:
Originally posted by Peso
What about named pipes? If it is a local database, I think named pipes will be used before TCP/IP.Peter LarssonHelsingborg, Sweden
For remote connections, You dont use named pipes. Stick to TCP/IP and uncheck named pipes |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2006-08-22 : 05:32:04
|
quote:
Originally posted by afrika
For remote connections, You dont use named pipes. Stick to TCP/IP and uncheck named pipes
Africa, he writes he is on local machine.quote:
Originally posted by WarrenAyen
Remote? It's on a local computer. So is VB...what is going on here? Is there a setting I've missed?
Peter LarssonHelsingborg, Sweden |
|
|
|
afrika
Master Smack Fu Yak Hacker
2706 Posts |
Posted - 2006-08-22 : 05:52:29
|
| Oh Am sorry, an oversight. However, i tend to stick to TCP/IP in MS SQL. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-08-22 : 12:29:58
|
| Warren, what server name are you using to connect to the database server? And what does hostname show from a cmd window?Tara Kizer |
|
|
|
WarrenAyen
Starting Member
5 Posts |
Posted - 2006-08-25 : 15:41:54
|
| I don't know... :( I don't know where to look...I'm sorry.Luckily this project was cancelled, so I have time to actually take a course on it this time, but thanks for all your help :)Warren AyenIBM |
|
|
|
|
[Express 2005] Unable to connect to datasource