Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
bradptti
Starting Member
3 Posts |
 Posted - 2010-11-05 : 15:49:09
|
| Hello All, I am sort of new to SQL Server Administration. I built an SQL Server about a year ago and it has been working great since. However, we made some upgrades to some servers and I wish to move the database from the current server to the new server. I installed the same SQL Server 2005 Express (SQLEXPR_ADV.EXE) onto the new server that is on the current server. I already had the current server creating BAK files every night of my database, so I tried to do the "Restore" option in SQL Server on the new server. My problem is that in my VB.NET application I use the following code to connect to the current database from VB.NET cn.Open("driver={sql server};server=TestServer;database=TestDB")I keep getting a "Failed Login" error. Now if I use the following code it connects just fine. cn.Open("driver={sql server};server=TestSERVER2;database=TestDB;User ID=sa;Password=testpassword")I tried un-installing and re-installing SQL server on the new server changing some of the advanced options, but nothing allows me to use the first code method. Does anybody have any suggestions?Thank You,Brad |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
bradptti
Starting Member
3 Posts |
Posted - 2010-11-08 : 07:53:52
|
| Yes, I tried setting to mixed mode. I am not sure what I would have done differently. |
 |
|
|
bradptti
Starting Member
3 Posts |
Posted - 2010-11-08 : 07:59:22
|
| I just realized probably the most important piece of this puzzle. My original code works fine connecting to the new SQL server when I am logged on but when I log on as one of the users that will use my program it gives this login failed error message. I am sure that it works for me since I am an administrator, but not sure why it does not work for the other users. Has to be some sort of permissions issue but I cannot figure it out. Windows permissions seem to be ok since when logged on as the other user, I can navigate to the folder on the server where the SQL Server database is stored with no problems. It must be some sort of SQL Server permissions issue. Sorry for leaving this out, it was late in the day on Friday and must not have been thinking clearly. Any ideas with this new information?Thanks,Brad |
|
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2010-11-08 : 11:19:00
|
| Could you confirm the relevant logon account exists on the target sql server? Jack Vamvas--------------------http://www.sqlserver-dba.com |
|
|
|
|
|
|
Failed Login