Visual Basic express sql server connection
I am trying to create a connection from VB 2005 Express to a database that may created with SQL Server 2005. I have a program which I wrote that connected to a Pervasive SQL database. Now my client has switched to MSSQL Server 2005. the error i hav is "login failed for user "IFCDU1-WS23\user" (It's on window authentication where there is no password.). I changed the connection string in my program to access MSSQL Server 2005 database however when I run the program I get no errors and the update query didnt work.
Re: Visual Basic express sql server connection
I suspect that it's trying to use SQL Server Express by default. In the Add Connection dialog (the one where you browse to the MDF file), click the Advanced... button in the lower right. SQL Server Express disallows remote connections by default. Have you changed that behaviour so you can connect to the server from a remote machine?
Re: Visual Basic express sql server connection
I have solved the problem already. Its due to the administrator login. manage to get the password and run as administrator so it works. The .mdf file is in the following path (local hard disk):
C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\
It may be something basic, since I am beginner.
Re: Visual Basic express sql server connection
To set up a SQL Server 2005 database and connect it to a WinForms application written in Visual Basic 2005. Ensure that you have configured the SQL Server 2005 Listeners. By default SQL Server 2005 is locked down and needs TCP/IP enabled.The steps detailed in this series can be taken using the free tools, too -- SQL Server 2005 Express and Visual Basic 2005 Express.