Go Back   TechArena Community > Software > Software Development
Become a Member!
Forgot your username/password?
Tags Active Topics RSS Search Mark Forums Read

Reply
 
Thread Tools Search this Thread
  #1  
Old 06-08-2009
Member
 
Join Date: Dec 2008
Posts: 70
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.
Reply With Quote
  #2  
Old 06-08-2009
Member
 
Join Date: Dec 2008
Posts: 128
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?
Reply With Quote
  #3  
Old 06-08-2009
Member
 
Join Date: Jan 2009
Posts: 163
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.
Reply With Quote
  #4  
Old 06-08-2009
Member
 
Join Date: Feb 2006
Posts: 185
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.
Reply With Quote
Reply

  TechArena Community > Software > Software Development
Tags: , ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "Visual Basic express sql server connection"
Thread Thread Starter Forum Replies Last Post
How to create Snake game in Visual Basic 2010 express BhushanB Software Development 7 22-01-2012 04:20 PM
How to use Visual Basic 2008 Express with Windows 7 Breath Software Development 5 28-01-2010 04:34 PM
Connect Visual Basic with SQL server database samualres Software Development 4 28-11-2009 08:37 AM
Issue with connection database in Visual Basic Capers Software Development 3 08-04-2009 08:40 PM
Visual Basic 2005 or Visual Basic 6 Aasha Software Development 5 15-01-2009 06:56 PM


All times are GMT +5.5. The time now is 06:37 AM.