Error connecting to SQL Server

Support documents related to Microsoft SQL Server, Microsoft SQL Server Express, Microsoft Access and Microsoft Excel Databases

Error connecting to SQL Server

Postby Pepe » Thu Jul 22, 2010 11:04 am

Hi,

We have a new client with A Dynamic AI Named User Server license. The setup is as follows:
a) Dynamic AI running on a Windows 2003 Server 64 bits
b) Microsft SL Server 2005 running on a Windows 2003 Server 64 bits


Afetr setting up IIS to be able to run in 32 bits mode Dynamic is working OK. Logged in as Administrator and changed passwords.

We are unable to make a connection to the SLQ Server from Dynamic.
We have trie with the server name and IP address of the machine. No special ports and only one instance of SQL running on that server. We have tried with different SQL users: SA and one created specifically to test with all the permissions. We keep getting "Error on initializing session for the user" (or something similar translated from Spanish).

With a Personal Edition on a PC on the network they were able to connect to the Database.

Any hints of what might be wrong?

TIA
Pepe
 
Posts: 4
Joined: Thu Jun 04, 2009 7:34 am
Location: Vigo - Spain

Re: Error connecting to SQL Server

Postby Carsten Sørensen » Fri Jul 23, 2010 8:19 pm

Hi Pepe,

Did you get a solution?

Best regards
Carsten
User avatar
Carsten Sørensen
Certified Dynamic AI Professional
 
Posts: 304
Joined: Thu Aug 16, 2007 1:25 pm
Location: Copenhagen

Re: Error connecting to SQL Server

Postby Pepe » Mon Jul 26, 2010 11:34 am

Problem just solved

The customer had some problems with MS-SQL restrictions, password expiration and user locking that he managed to solve this morning.

Thanks
Pepe
 
Posts: 4
Joined: Thu Jun 04, 2009 7:34 am
Location: Vigo - Spain


Return to Microsoft SQL Server / Express / Access / Excel

cron