December 2, 2009 at 10:00 am
Hello comunity
I will try to test demo program : AZsql Decryptor and when i try to login on my sql server 2008 Workgroup on my machine , i have the following error :
DAC Login Failed, MS SQL 2005/2008 Connection Error.
[DBNETLIB][ConnectionOpen(Connect()).]SQL Server does not exist or
access denied
Could this error occure due to permission, MDAC version or another thing else that can possibly accured.
Someone have an ideia.
Many thanks
Best regards
LuisSantos
December 2, 2009 at 10:08 am
I suspect that either the connection string the program is using is incorrect or a permissions issue to the server itself. Can you connect to the SQL Server instance by creating an ODBC connection or by using SQL Server Management Studio?
Aunt Kathi Data Platform MVP
Author of Expert T-SQL Window Functions
Simple-Talk Editor
December 2, 2009 at 10:14 am
I just downloaded and installed the program. When I click "Connect" I am able to select the server, authentication, and database. It works for me. Make sure that you are supplying the correct values and that you do have rights to the SQL Server instance.
Aunt Kathi Data Platform MVP
Author of Expert T-SQL Window Functions
Simple-Talk Editor
December 2, 2009 at 10:53 am
Hello Kathy
Yes, if i loggin throught SQL managment Studio, everythings work fine.
Actually, your OS is Windows 7 X86 ??
December 2, 2009 at 11:08 am
No, I am running my work laptop which has Windows XP and a local instance of SQL Server 2008. From your original post, it looks like you are running SQL Server locally, too. If you are supplying correct connection info, I don't see why this wouldn't work.
Aunt Kathi Data Platform MVP
Author of Expert T-SQL Window Functions
Simple-Talk Editor
December 2, 2009 at 11:13 am
When I try to connect to a remote instance, I get an error about using the DAC. Maybe that is part of the issue.
Aunt Kathi Data Platform MVP
Author of Expert T-SQL Window Functions
Simple-Talk Editor
December 2, 2009 at 11:28 am
Hello Kathy
I think the problem is not on SQL server 2008, but is on my Os Windows 7 , because like i said , throught Managment Studio or throught ODBC on my local machine or when i connect to my server theses problems does not occurs.
Also, before changing to Windows 7on my Windows Vista this problem has never occur.
Have you an ideia.
Many thanks
Luis Santos
December 2, 2009 at 11:49 am
With this program, it makes a difference whether the SQL Server instance is local or not because it uses the DAC to connect. This feature is disabled for remote connections by default. So, I am still not sure if you are running SQL Server locally or connecting to a remote instance.
Aunt Kathi Data Platform MVP
Author of Expert T-SQL Window Functions
Simple-Talk Editor
December 2, 2009 at 3:54 pm
Hello Kathy
i´am running SQL Server locally not on remote instance.
I try also to configure SQL server to allow remote connection but i have always the same error.
I think the problem is on Windows 7 and not on SQL Server 2008, but i don´t know why??
If you find another way i hope you tell me.
Many thanks
Luis Santos
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply