Sql 2012 , OBDC

Well let's start from the first
i had some troubles with using sql 2005
so i moved to sql 2012 ..
The problems were solved but another came up
When i add kal_db
I have the normal one ..
And i can't restore while using it so
i use kal_dbmssql2005.bak
and the auth too
and they were restored sucessfully
but when i go to the ODBC
and add , kal_db and next
There's a
Connect to sql server to obtain the default options
Picture of it
Attachment 134238
When its marked .. I press next after a while ..
this pops up
Attachment 134239
When i unmark it and continue as usual
Finish ..
Test data resource ..
When i press test ..
This came up
Attachment 134240
Hope any1 figure the problem here ..
:)
Reply with solutions
No aggresive comments please ..

http://forum.ragezone.com/f554/tutor...-using-209151/


~Now onto the ODBC

~Go into start -- control panel -- administrative tools -- Data Sources (ODBC)

~Go into system DSN and click on "add"

~Now search for "SQL server". Select it and click on finish

~Name it KAL_AUTH and for "which SQL server do you want to connect to?" select (local)
http://img242.imageshack.us/img242/7...tledni7.th.jpg

~Click next-next- then check "change the default database to" and select "kal_auth"

~click next two more times and then OK

~Do the same thing for kal_db

If you can't open the control panel trough "start -- control panel" go "start--run--control panel.


reason:you did somthing wrong. check what you write where and change where is wrong i cant help you out since i dont know which are the infos you use for ODBC and which ones you have to use.

yes i have the same problem.and don't fixed with this answer:grr:

Quote:

---

Originally Posted by DivisionKal

yes i have the same problem.and don't fixed with this answer:grr:

---

send me a p message with your skype or email
i will help you using teamviwer ..

or add me
Skype : MrHeth

i send request at skype

i know the problem ,, you should reinstall it and make sure when you reinstall it , chose mixed mode ( windows authentication and sql server authentication then write your password and continue the install then try to make new data source and chose ( with sql server authentication using a login id and password entered by the user
the id will be same always : sa
password what you write in start when installing , have fun