1rightman
19-12-06, 11:58 AM
Salam brothers and sisters,
I am using Microsoft Access Query using VB6 command.
Now want to change the data to SQL and was successfully imported to SQL SERVER 2005.
I can open the table and query ( view ) using SQL SERVER MANAGEMENT STUDIO.
But when I try to run the program using VB6 command, it always say that " I do not have permission to log-on to SQL server.
I am using windows xp pro SP2.
SQL SERVER authentication is both windows authentication as well as sql server authentication.
I am very new to SQL server.
Kindly help me to solve this problem.
I am using Microsoft Access Query using VB6 command.
Now want to change the data to SQL and was successfully imported to SQL SERVER 2005.
I can open the table and query ( view ) using SQL SERVER MANAGEMENT STUDIO.
But when I try to run the program using VB6 command, it always say that " I do not have permission to log-on to SQL server.
I am using windows xp pro SP2.
SQL SERVER authentication is both windows authentication as well as sql server authentication.
I am very new to SQL server.
Kindly help me to solve this problem.