I Changed My Servername Help Please

Hi,
I have Joined my SQL Server into another domain and had to rename the
machine as well I am running SQL Server 2000 on a Windows 2000 server on an
NT Domain
Since this I seem to have some problems with replication etc. is there a
registry setting or something I need to change where the old machine name
might be lurking?
Or is it a case of me removing then re-installing SQL Server ?
Thanks in advance for any help provided on this
Joe MellonIf you re-run the Setup from the SQL Server CD, it should show you an option
to repair registry only. Try with this first, it is quick and easy process.
You don't have to reinstall SQL Server. Maybe after the registry rebuild you
will have only to reestablish the replication.
--
Dejan Sarka, SQL Server MVP
Please reply only to the newsgroups.
"Joe Mellon" <joe@.bluesteel.co.uk> wrote in message
news:O9vZofNsDHA.2492@.TK2MSFTNGP12.phx.gbl...
> Hi,
> I have Joined my SQL Server into another domain and had to rename the
> machine as well I am running SQL Server 2000 on a Windows 2000 server on
an
> NT Domain
> Since this I seem to have some problems with replication etc. is there a
> registry setting or something I need to change where the old machine name
> might be lurking?
> Or is it a case of me removing then re-installing SQL Server ?
> Thanks in advance for any help provided on this
>
> Joe Mellon
>

I can't stat SQL in a user account

Windows 2000 SP4 and SQL Server 2000 SP3
When I try to start SQL Server in the account
DOMAIN\Administrator, the system return the error 22042 (-
2147024890).
I can not start in a user account and I can not send
email.
Could you help me please ? ThanksAre you logged on to NT box using a domain admin account ?
if not then I don't think it will let you specify a
Domain\Administrator as a sql service start up account. It
would be a gross violation of security principles. Specify
the same account that you are using to log in to the
system, or a local administrator.
hth.
>--Original Message--
>Windows 2000 SP4 and SQL Server 2000 SP3
>When I try to start SQL Server in the account
>DOMAIN\Administrator, the system return the error 22042 (-
>2147024890).
>I can not start in a user account and I can not send
>email.
>Could you help me please ? Thanks
>.
>|||I am logged with the DOMAIN\Administator on the server
when I tried to set up it.
But if I am logged with a other account with the admin
rights I have the same message.
>--Original Message--
>Are you logged on to NT box using a domain admin
account ?
>if not then I don't think it will let you specify a
>Domain\Administrator as a sql service start up account.
It
>would be a gross violation of security principles.
Specify
>the same account that you are using to log in to the
>system, or a local administrator.
>hth.
>>--Original Message--
>>Windows 2000 SP4 and SQL Server 2000 SP3
>>When I try to start SQL Server in the account
>>DOMAIN\Administrator, the system return the error 22042
(-
>>2147024890).
>>I can not start in a user account and I can not send
>>email.
>>Could you help me please ? Thanks
>>.
>.
>|||the error you are getting is about the server not able to
verify the user account you specified. type following
command on DOS command prompt just to make sure the domain
controller is responding:
net users /DOMAIN
This should list all users in the domain you are logged
into.
Try using Local System Account in service startup for sql
server.
hth.
>--Original Message--
>I am logged with the DOMAIN\Administator on the server
>when I tried to set up it.
>But if I am logged with a other account with the admin
>rights I have the same message.
>>--Original Message--
>>Are you logged on to NT box using a domain admin
>account ?
>>if not then I don't think it will let you specify a
>>Domain\Administrator as a sql service start up account.
>It
>>would be a gross violation of security principles.
>Specify
>>the same account that you are using to log in to the
>>system, or a local administrator.
>>hth.
>>--Original Message--
>>Windows 2000 SP4 and SQL Server 2000 SP3
>>When I try to start SQL Server in the account
>>DOMAIN\Administrator, the system return the error 22042
>(-
>>2147024890).
>>I can not start in a user account and I can not send
>>email.
>>Could you help me please ? Thanks
>>.
>>.
>.
>|||The command DOS net users /DOMAIN is OK. I can see le the
users list in the domain.
But if I use the local system account I cant send email
with SQL Agent and I need it.
>--Original Message--
>the error you are getting is about the server not able
to
>verify the user account you specified. type following
>command on DOS command prompt just to make sure the
domain
>controller is responding:
>net users /DOMAIN
>This should list all users in the domain you are logged
>into.
>Try using Local System Account in service startup for
sql
>server.
>hth.
>>--Original Message--
>>I am logged with the DOMAIN\Administator on the server
>>when I tried to set up it.
>>But if I am logged with a other account with the admin
>>rights I have the same message.
>>--Original Message--
>>Are you logged on to NT box using a domain admin
>>account ?
>>if not then I don't think it will let you specify a
>>Domain\Administrator as a sql service start up
account.
>>It
>>would be a gross violation of security principles.
>>Specify
>>the same account that you are using to log in to the
>>system, or a local administrator.
>>hth.
>>--Original Message--
>>Windows 2000 SP4 and SQL Server 2000 SP3
>>When I try to start SQL Server in the account
>>DOMAIN\Administrator, the system return the error
22042
>>(-
>>2147024890).
>>I can not start in a user account and I can not send
>>email.
>>Could you help me please ? Thanks
>>.
>>.
>>.
>.
>sql

I cant connect to a domain account! HELP!

Hi

Doing webforms in ASP.NET and i have a connection string in the webconfig that connects to a locally created SQL Server user account.

This is fine however when i try to connect to a domain account created by the IT administrator for me, it wont work.

The User name and password he supplied are correct as i logged into my PC (Win 2000) using it to test it. However when i try to connect to this remote network domain account by changing my connection string it fails... anyone any ideas, or am i missing a subtlety of ASP.NET and SQL connectionstrings?

Heres the connection string that works...
ConnectionString = value="Server=MY-SERVER;Network Library=DBMSSOCN;Initial Catalog=MYDATABASE2;User ID=MrLocalUser;Password=password;"

Heres the connection string that fails...
ConnectionString = value="Server=MY-SERVER;Network Library=DBMSSOCN;Initial Catalog=MYDATABASE2;User ID=DOMAIN\MrDomainUser;Password=password;"

??I'm not convinved that you can connect to a Sql Server using a windows account without using integrated security. Basically there are two type of authentication for SQL Server, "SQL Server" where you pass a username and password & "Window Integrated" where it passes the identity that the application is running. A connection string for this would be something like this:

ConectionString = "Server=MY-SERVER;Network Library=DBMSSOCN;Initial Catalog=MYDATABASE2;Integrated Security=SSPI"

So if you are running your ASP.NET application under the default user, the credentials passed would be:
[localmachine]\ASPNET

If you want to get it connect to the database using that specific account, you have a couple of options.

1) Change the identity that the asp.net application runs under. You can do this in the web.config file (i.e. to allow you to specify the specific user that the application runs under)

2) Switch on Impersonation, and have it run under the identity of the person logged into the application.

These both start to get a bit more involved, as it means you will need to ensure that the user that the process is running under has the appropriate permissions throughout the application, and also within the Framework folders.

Here's some info on Impersonation:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpguide/html/cpconaspnetimpersonation.asp

Here's some further reading on changig the Asp.Net identity:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vsent7/html/vxconApplicationIdentity.asp

Hope this helps

Regards

Darren

MCSD.net