I am trying to create a Visual Basic 2005 app and connecting it to SQL Server 2005 Express Edition (bundled with VB 2005)
but i am getting errors
I just want to know if there is any configuration that i need to perform on SQL server before attempting to connect VB 2005 App with SQL Server 2005
My sql server 2005 configuration is default.. that is i am only listening to local connection (remote connections, piped and tcp/ip connections are disabled).
I am running 512 MB ram, 160 GB hard drive, Windows XP SP2 with all the updates
Please help..
Asim Zeeshan
Error connecting to SQL Server 2005 local instance using VB 2005 app
catalinione
sabo
Well i figured out the problem...
When you install VS 2005 with SQL 2005 express edition you need to go to:
Start - > Programs - > Microsoft SQL Server 2005 - > Configuration Tools -> SQL Server Surface Area Configuration
Then click on "Sarface Area Configurations for Services and Connections"
1) There, you need to start the SQL browser (make it to start AUTOMATICALLY)
2) Got o remote connections and enable named pipe connections
restart the sql server (or the PC) and try again... :) it works for me
Morn
This is the exect error msg i get...
When I try creating a new connettion, I select SQL server, I select Windows Authentication (bcoz its a local sql server instance and that i configured it this way) then when I go to click on the dropdown to select the databse to connect to, I get a delay of about 2 minutes and i get the following error message
"An error has occurred 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." additional it gives error 40 something...
bflemi3