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
[Only registered and activated users can see links. Click Here To Register...]
click Add > SQL Server
[Only registered and activated users can see links. Click Here To Register...]
click Finish
type in Name - ACCOUNT
type in Server - (local) (or use dropdown menu)
[Only registered and activated users can see links. Click Here To Register...]
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
[Only registered and activated users can see links. Click Here To Register...]
press Next
select Change the default database to:
select account
[Only registered and activated users can see links. Click Here To Register...]
press Next
do not change anything in this window just press Finish
[Only registered and activated users can see links. Click Here To Register...]
press Test Data Source...
[Only registered and activated users can see links. Click Here To Register...]
if you did all correctly you should see following window
[Only registered and activated users can see links. Click Here To Register...]
now press OK and close all windows by clicking OK
and thats it server should run now without errors
~commandcom
Step1:
go to Control Panel > Administrative Tools, open Data Sources (ODBC)
select System DSN
[Only registered and activated users can see links. Click Here To Register...]
click Add > SQL Server
[Only registered and activated users can see links. Click Here To Register...]
click Finish
type in Name - ACCOUNT
type in Server - (local) (or use dropdown menu)
[Only registered and activated users can see links. Click Here To Register...]
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
[Only registered and activated users can see links. Click Here To Register...]
press Next
select Change the default database to:
select account
[Only registered and activated users can see links. Click Here To Register...]
press Next
do not change anything in this window just press Finish
[Only registered and activated users can see links. Click Here To Register...]
press Test Data Source...
[Only registered and activated users can see links. Click Here To Register...]
if you did all correctly you should see following window
[Only registered and activated users can see links. Click Here To Register...]
now press OK and close all windows by clicking OK
and thats it server should run now without errors
~commandcom