changing SQL server service account

Guys,
I have got WINDOWS 2000 Advanced Server and MS SQL SERVER 7.0 running on my live server. Now when we are planning for replication, we have found that SQL server will require to run under a domain account. At the moment there are so many ASP pages running on our server accesses different databases created using SQL server 7.0. Most of them are DSN connections to the database. Now if i create a domain account and restart the server and MS SQL services with the domain account, how is it going to effect the current web pages running on it?
Any help will be greatly appreciated.
ThanksA connection to a database has no bearing on what account starts the sql server service. However the account used does affect how the server interacts with other sql servers, or other machine resources, you found that out when you tried to implement replication using LocalSystem account. You can search msdn for "sql server service account" to get a better understanding of the purpose of accounts for sql server.|||Thanks very much Greg,
your reply helped me to have better understanding.
I would find out more from MSDN as you have suggested.
Cheers.

Changing server name

I need to change the server name of a live SQL server. Aside for re-creating
ODBC connections; are there any issues doing this?
Hi,
You could use sp_dropserver and sp_addserver system procedures to change
server name. There wil not be any issues
apart from changes in connection strings . But this change require a restart
of SQL Server service.
No need to restart the server.
Thanks
hari
SQL Server MVP
"Peretz Stern" <peretzstern@.optonline.net> wrote in message
news:eECNEvHmFHA.3780@.tk2msftngp13.phx.gbl...
>I need to change the server name of a live SQL server. Aside for
>re-creating ODBC connections; are there any issues doing this?
>

Changing server name

I need to change the server name of a live SQL server. Aside for re-creating
ODBC connections; are there any issues doing this?
Hi,
You could use sp_dropserver and sp_addserver system procedures to change
server name. There wil not be any issues
apart from changes in connection strings . But this change require a restart
of SQL Server service.
No need to restart the server.
Thanks
hari
SQL Server MVP
"Peretz Stern" <peretzstern@.optonline.net> wrote in message
news:eECNEvHmFHA.3780@.tk2msftngp13.phx.gbl...
>I need to change the server name of a live SQL server. Aside for
>re-creating ODBC connections; are there any issues doing this?
>

Changing server name

I need to change the server name of a live SQL server. Aside for re-creating
ODBC connections; are there any issues doing this?Hi,
You could use sp_dropserver and sp_addserver system procedures to change
server name. There wil not be any issues
apart from changes in connection strings . But this change require a restart
of SQL Server service.
No need to restart the server.
Thanks
hari
SQL Server MVP
"Peretz Stern" <peretzstern@.optonline.net> wrote in message
news:eECNEvHmFHA.3780@.tk2msftngp13.phx.gbl...
>I need to change the server name of a live SQL server. Aside for
>re-creating ODBC connections; are there any issues doing this?
>

Changing server name

I need to change the server name of a live SQL server. Aside for re-creating
ODBC connections; are there any issues doing this?Hi,
You could use sp_dropserver and sp_addserver system procedures to change
server name. There wil not be any issues
apart from changes in connection strings . But this change require a restart
of SQL Server service.
No need to restart the server.
Thanks
hari
SQL Server MVP
"Peretz Stern" <peretzstern@.optonline.net> wrote in message
news:eECNEvHmFHA.3780@.tk2msftngp13.phx.gbl...
>I need to change the server name of a live SQL server. Aside for
>re-creating ODBC connections; are there any issues doing this?
>

Changing path of web service?

I have 2 report services servers one for development and one for live, I
need to add a reference to the web service in my app, but during development
it has to refernce development server, during deployment it has to reference
what ever the end user calls their server, can you change the reference url
of a web service at run time? if so how? thanks! the web services will all
have the same definition at all times. I'm also doing this in VB.NETSmokey Grindle wrote:
> I have 2 report services servers one for development and one for live, I
> need to add a reference to the web service in my app, but during development
> it has to refernce development server, during deployment it has to reference
> what ever the end user calls their server, can you change the reference url
> of a web service at run time? if so how? thanks! the web services will all
> have the same definition at all times. I'm also doing this in VB.NET
IIRC, when you declare an instance of the web service, you can set it's
URL property to the correct one.

Changing DataSource

HI,
I am having a problem and its very urgent,
i have made a report in test database it worked fine, now i wana run it on live database, i have changes its datasource and updated it as well, but agin its piking data from test database.
i cant understand why????
i have refreshed the report, logged in logged off , evry thing possible i have done but it is picking data from test database :(

can any one help me?i have made the TEST database offline now its show error message that TEST data base is offline......i could not understand why it is going for TEST database....when i have updated datasource with LIVE one....!!!

every where it is shown LIVE database but when i m goin to refresh it it goes for TEST :(

plzzzzzzzzzzzzzzz can any 1 help ???|||Problem resolved :)
it was my mistake i was not maping all tables one by one...!! was just maping database...!!!