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 |
|
J Trahair
Starting Member
15 Posts |
 Posted - 2011-04-07 : 07:50:00
|
Hi. I have a VB.Net app running on a computer which links to a SQL Server on the same machine. No problem yet. We have a new computer on the network which now has SQL Server 2005 and the restored backup from the first SQL Server.We want to point the VB.Net app to the SQL Server on the new computer (the first computer still has its SQL Server running).The connection string isServer=COMPUTER1\SQLEXPRESS;Database=Whatever;User ID=sa;Password=whateveragain;Trusted_Connection=False; I tried changing COMPUTER1\SQLEXPRESS to NEWCOMPUTER\SQLEXPRESS in the above string, but no deal.Is there a setting in SQL Server on NEWCOMPUTER that needs changing?Thank you. |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
|
|
raghuveer125
Constraint Violating Yak Guru
285 Posts |
Posted - 2011-04-07 : 07:59:04
|
| Check second Or NEWCOMPUTER computer having only one default instance? Check this by opening services in second or NewComputer find SQL Server(SQLEXPRESS)If this is change this wont work.Next If this is your default instance with (SQLEXPRESS) then check whether sa password is matching.Raghu' S |
 |
|
|
J Trahair
Starting Member
15 Posts |
Posted - 2011-04-07 : 09:06:30
|
| Thank you for prompt and detailed replies! |
|
|
|
J Trahair
Starting Member
15 Posts |
Posted - 2011-04-12 : 08:17:38
|
| Hi again. I have followed the above instructions, and also did a 'Firewall Rule for Sql Server 2005 on Windows 7' thing (http://jwwishart.wordpress.com/2009/10/27/firewall-rule-for-sql-server-2005-on-windows-7/) - all on the new server (32bit), but the Win7 64bit app still does not connect to the Win7 32bit server.What else can I try. Uninstall SQL Server Express on the Win7 64bit? |
|
|
|
Bustaz Kool
Master Smack Fu Yak Hacker
1834 Posts |
Posted - 2011-04-13 : 14:41:22
|
| Just to remove the obvious, can you log into the new server using the credentials in your connection string via SSMS on your machine? Also, what error are you actually experiencing?=======================================Elitism is the slur directed at merit by mediocrity. -Sydney J. Harris, journalist (1917-1986) |
|
|
|
|
|
|
Changing from one server to another