Re: restore problem about sql server
- From: "SSK" <suthramsk@xxxxxxxxx>
- Date: 31 Aug 2005 22:16:57 -0700
Hi,
You did not mention what kind of error you are getting.
If you are getting access denied error then make sure your Sql instance
authentication is eiter mixed mode or in SQl server authentication mode
and check the user has proper permission on that server, the easiest
way to check is open query analyzer from your laptop and give the same
server name(type id down), userid and password.
besides this make sure both database server and your laptop are in the
same domain and also you can try switching off the windows xp fire
wall.
bye
ssk
Dee wrote:
> thx, erland,
> I think the databse is working properly right now.
> it must be some OS environment problems that prevent the application
> accessing the database.
> caze i migrate the application to my laptop and also install the SQL
> server on my laptop to access the database, it works. it just means,
> the laptop is my application server ,and the original server is just
> the database server.
> thus, there is sth wrong with my IIS setting probably, but I dont know
> how to fig it out.
> anyone can help?
.
- References:
- Re: restore problem about sql server
- From: Erland Sommarskog
- Re: restore problem about sql server
- From: Dee
- Re: restore problem about sql server
- Prev by Date: Re: Memory usage in SQL Server
- Next by Date: Re: restore problem about sql server
- Previous by thread: Re: restore problem about sql server
- Next by thread: Re: restore problem about sql server
- Index(es):
Relevant Pages
|
