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 |
|
JimmyNeutron
Starting Member
2 Posts |
 Posted - 2011-03-10 : 23:47:20
|
| Hi,I've been working on this for the last few days and couldn't figure out why the program I'm using can connect to MS SQL 2008 R2 Express 32bit, but not the 64bit version.Here's my setup for 32bit:1. Clean install of Windows 7 SP1 64bit. No changes or updates install at all to Windows 7 SP1.2. Install SQL 2008 Express Database w/ Management Tools 32bit.3. Install my program and it will look for the database server and try to connect to it. Program is install on the same computer that SQL was installed onto.Results: It sees the database server and everything works fine.Here's my setup for 64bit:1. Clean install of Windows 7 SP1 64bit(64bit for both 32/64bit setup). No changes or updates install at all to Windows 7 SP1.2. Install SQL 2008 Express Database w/ Management Tools 64bit.3. Install my program and it will look for the database server and try to connect to it. Program is install on the same computer that SQL was installed onto.Results: It cannot log into the database and cannot continue w/ the installation.I've compare the settings between 32/64bit SQL 2008 R2 Express and see no differences.Program I'm using is Vivotek ST7501 which is used for my NVR.http://www.vivotek.com/downloads/downloads.php?kind=software.Anyone have any idea why I cannot connect to the 64bit version of MS SQL 2008 R2 Express - Database w/ Management Tools?Thanks in advance! |
|
|
lappin
Posting Yak Master
182 Posts |
Posted - 2011-03-14 : 08:15:31
|
| Double check the instance name you are using to connect from program is correct. Run this in management studio to get instance name:select @@SERVERNAME |
 |
|
|
JimmyNeutron
Starting Member
2 Posts |
Posted - 2011-03-15 : 17:10:29
|
quote:
Originally posted by lappin
Double check the instance name you are using to connect from program is correct. Run this in management studio to get instance name:select @@SERVERNAME
Thanks! I did double check the instance name for the program and it is correct. I'm using the Default Instance name during the installation of SQL 2008 R2 Express and Windows as the authentication type.That's why I'm puzzled as to why my NVR program works w/ the 32bit version and not the 64bit version. I don't think the program I'm using cares if it's a 32bit or 64bit database.I kept all settings identical during the installation of the 32bit and 64bit of SQL. The NVR program settings is the same, but it just can't connect to the 64bit version of SQL. |
|
|
|
|
|
|
Program cannot connect to SQL 2008 R2 x64