- Joined
- Jan 22, 2005
- Messages
- 889
- Reaction score
- 80
As alot people have the same problem as i had i will make little tutorial how to make ODBC account
Step1:
go to Control Panel > Administrative Tools, open Data Sources (ODBC)
select System DSN
click Add > SQL Server
click Finish
type in Name - ACCOUNT
type in Server - (local) (or use dropdown menu)
press Next
select With SQL Server authentication using a login ID and password entered by th user
type in your Login ID (default sa)
type in your Password that you did use in SQL Server registration
press Next
select Change the default database to:
select account
press Next
do not change anything in this window just press Finish
press Test Data Source...
if you did all correctly you should see following window
now press OK and close all windows by clicking OK
and thats it server should run now without errors
proof:
Step1:
go to Control Panel > Administrative Tools, open Data Sources (ODBC)
select System DSN
click Add > SQL Server
click Finish
type in Name - ACCOUNT
type in Server - (local) (or use dropdown menu)
press Next
select With SQL Server authentication using a login ID and password entered by th user
type in your Login ID (default sa)
type in your Password that you did use in SQL Server registration
press Next
select Change the default database to:
select account
press Next
do not change anything in this window just press Finish
press Test Data Source...
if you did all correctly you should see following window
now press OK and close all windows by clicking OK
and thats it server should run now without errors
proof:
Last edited: