Problem in SQL Server 2008 [Help]

i installed SQL Server 2008 then i used Server name: SQLExpress
i restore Database then i open DataServer 1 and DataServer2 then it say ODBC Error
how can i fix it?

- - - Updated - - -

up-yup

configure your odbc.

Quote:

---

Originally Posted by psychedelic

configure your odbc.

---

how to configure ODBC?

In your database folder you should have the stranded databases MuOnline,MuRanking,MuEvent

And in that database folder they should be odbc.reg

if so double click that and click ok thats how you register it!

i run it already
but when i run Dataserver is says ODBC error

open ODBC.req and where it says (local)
go to start> find service manager> and copy the name of the service running example GAYMAR001/SQLEXPRESS
then replace (local) with that name in every line at odbc.req and save and run it again , then try again.

Quote:

---

Originally Posted by GMO

open ODBC.req and where it says (local)
go to start> find service manager> and copy the name of the service running example GAYMAR001/SQLEXPRESS
then replace (local) with that name in every line at odbc.req and save and run it again , then try again.

---

thnx i'll try it

- - - Updated - - -

Quote:

---

Originally Posted by GMO

open ODBC.req and where it says (local)
go to start> find service manager> and copy the name of the service running example GAYMAR001/SQLEXPRESS
then replace (local) with that name in every line at odbc.req and save and run it again , then try again.

---

http://i260.photobucket.com/albums/i...ps0b373de7.jpg

http://i260.photobucket.com/albums/i...ps6c41e8d0.jpg

http://i260.photobucket.com/albums/i...psaedb39c9.jpg

http://i260.photobucket.com/albums/i...ps14bfd35f.jpg

- - - Updated - - -

up up up

not just SQLEXPRESS Mate
your PC-NAME\SQLEXPRESS

Try that

What are the databases that your restore? And what are the databases that you have? Do you have this databases?

1. MU2003_EVENT_DATA
2. MuOnline
3. Ranking
4. SCFMu

Quote:

---

Originally Posted by asiatique

What are the databases that your restore? And what are the databases that you have? Do you have this databases?

1. MU2003_EVENT_DATA
2. MuOnline
3. Ranking
4. SCFMu

---

only 1 DB sir "MuOnline" Only

Quote:

---

Originally Posted by GMO

not just SQLEXPRESS Mate
your PC-NAME\SQLEXPRESS

Try that

---

i will try re-install sql server 2008 then i want to use (local) as server name

you better use sql 2000 if you dont want to have issues.

Or much better to use server files that are on release section rather than still on development. :rolleyes:

Quote:

---

Originally Posted by asiatique

Or much better to use server files that are on release section rather than still on development. :rolleyes:

---

thank you for your suggestion

maybe my problem is ODBC connection :)

Reinstall SQL without "Instance" so you won't get problems on your ODBC.reg