asked on
SQL Server Express - Can't connect to the database
I'm using VB.Net to run a program that connects to a SQL Server Express database.
My connection string is this:
Here is the error message I'm getting.![orderr_trans_error.jpg]()
This program has been running all day and only stopped about an hour ago.
Nothing was changed on our system as far as we can tell - and no code was changed in the VB.Net program.
Any suggestions on things we can try? This problem happend a couple of days ago - and after a few hours it started working. Very odd.
I can access the database using the credentials I have using Management Studio.
Any help or suggestions you have will be appreciated!
Thank you!
Steve
My connection string is this:
Public Const LocalDB As String = "User ID=sa;Password=*******;Initial Catalog=tempOrders;Data Source=v7p\SQLEXPRESS"
Here is the error message I'm getting.
This program has been running all day and only stopped about an hour ago.
Nothing was changed on our system as far as we can tell - and no code was changed in the VB.Net program.
Any suggestions on things we can try? This problem happend a couple of days ago - and after a few hours it started working. Very odd.
I can access the database using the credentials I have using Management Studio.
Any help or suggestions you have will be appreciated!
Thank you!
Steve
DatabasesMicrosoft SQL ServerVisual Basic.NETSQL
Last Comment
slightlyoff
Attachment missing,?
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
v7p is the same computer the program is running on. The SQL Server Express and the vb.net program are running on the same machine.
My system admin insist that the firewall isn't blocking anything - but they're not here, so it'll take a little bit for me to get them to double check.. Windows Firewall is disabled and managed by the system admin.
For what it's worth, I can ping v7p.
My system admin insist that the firewall isn't blocking anything - but they're not here, so it'll take a little bit for me to get them to double check.. Windows Firewall is disabled and managed by the system admin.
For what it's worth, I can ping v7p.
ASKER
Thanks for your help, but the error is a false positive. It's trying to connect to another server for a separate operation. Thanks though!