Error 193 installing

When installing SQL Server 2005 the first component to be installed by the setup it is it (.NET Framework 2.0), but it happens the following mistake
" Error 193 installing .NET Framework 2.0 "... what is doing wrong and which would be solution

You can try to install .NET 2.0 from windows update or download it separatly and try to install it manually.

http://www.microsoft.com/downloads/details.aspx?familyid=0856EACB-4362-4B0D-8EDD-AAB15C5E04F5&displaylang=en

If it still fails try to include all error messages as it might give a better idea what is going on.

Have you had any Visual Studio 2005/.NET 2.0 beta versions installed?

Error 1923 while installing SQL 2005 Express

This is from the event log

Product: Microsoft SQL Server 2005 Express Edition -- Error 1923. Service 'SQL Server ()' () could not be installed. Verify that you have sufficient privileges to install system services.

I've tried uninstalling through control panel and various cleanup tools and tried reinstalling with no luck.

I'm logged on with a user that has full admin rights.

1923 is an RPC error that translates to "The specified profile entry could not be added." You'll need to search through the SQL Server Setup log files for more detail on what went wrong. Start by looking here and in the subdirectory:

C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG

Paul

|||I am having the same problem. Did you figure out a work around?

|||I have found NO answer to this question anywhere online. I got mine working last night here is what I did:
I was trying to install it on a VPS I only have licensing for one terminal server session and I noticed that earlier in the day my RDP connection had timed out and I was still logged in so I kicked the old connection uninstalled all instances of SQL and tried again. Guess what? it didn't work...lol So I uninstalled everything again and restarted the VPS and then it installed. I have no idea exactly what was wrong but that is how I solved it. Hope it helps someone else out.
sql

Error 1923 while installing SQL 2005 Express

This is from the event log

Product: Microsoft SQL Server 2005 Express Edition -- Error 1923. Service 'SQL Server ()' () could not be installed. Verify that you have sufficient privileges to install system services.

I've tried uninstalling through control panel and various cleanup tools and tried reinstalling with no luck.

I'm logged on with a user that has full admin rights.

1923 is an RPC error that translates to "The specified profile entry could not be added." You'll need to search through the SQL Server Setup log files for more detail on what went wrong. Start by looking here and in the subdirectory:

C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG

Paul

|||I am having the same problem. Did you figure out a work around?

|||I have found NO answer to this question anywhere online. I got mine working last night here is what I did:
I was trying to install it on a VPS I only have licensing for one terminal server session and I noticed that earlier in the day my RDP connection had timed out and I was still logged in so I kicked the old connection uninstalled all instances of SQL and tried again. Guess what? it didn't work...lol So I uninstalled everything again and restarted the VPS and then it installed. I have no idea exactly what was wrong but that is how I solved it. Hope it helps someone else out.

Error 1920. Service 'ReportServer' (ReportServer) failed to start

Hello, I cannot install Reporting Services Developer Version, at the end of
the setup I got a message like:
Error 1920. Service 'ReportServer' (ReportServer) failed to start. Verify
that you have sufficient privileges to start system services.
I have SQL SP3a, IIS, .NET 2003 all in the same computer.
Just cannot find how to solve the problem, seems to be something with the
account used to start the service, but with neither the built in account, not
a computer admin account can continue. Have no problem creating the database,
just to start the service.
Help pleaseMy problem is solved; I think you only need to change the installation path
of RS during the setup, but the following are the steps I follow:
1. Uninstall RS
2. Clean all signs of RS in the registry, the service and components
Delete in the registry the entries in
HKEY_LOCAL_MACHINE\System\CurrentControlSet\Services\RS Rep..
Delete the service from the command prompt
sc delete ReportServer
Delete the components in Component Services in
the control panel Administrative Tools in the COM+ Applications for the ISS
3. Install RS in a different path
I install RS in C:\Program Files\Microsoft SQL ServerRS
Also i rename the services in the setup to MSReportService, MSReports for
the
IIS part.
I have Windows XP with all in one box; I use a domain account, for the
services
and for the SQL login.

Error 1911 replication column does not exist

Source server MSSQL7.0
Destination server MSSQL2K

I'm setting up replication for reporting purposes to another SQL-server.
When I start the distribution agent I get the following error:
Column name '<here's the name of a column I didn't publish and don't need to replicate>' does not exist in the target table.
Error number: 1911

I assume this is because of some dependencies between the columns.

Is there any way I can replicate without those columns?

RegardsDependency doesn't get replicated unless you specified. If you think the error was caused by the column dependency, check the unique index and the foreign key constraint to see whether the 'for replication' is checked or not.|||Thanks, you gave me the hint I needed.
I was scripting the creation of the publication because I need to setup replication for over 20 db's.
In the script you have to change the sp_addarticle @.schema_option value.

Regards

Error 18483 while configuring distributor

I want to setup a publisher, distributor and subscriber on the same machine.
While configuring my distributor using Wizard, I received the following
error:
Error 18483: Could not connect to server 'HONB" because "distributor_admin"
is not defined as a remote login at the server.
I am using SQL Server Developer version and "HONB" is my computer name. Can
someone tell what I have mis-configed?
This is usually a naming issue.
Try:
Use Master
go
Select @.@.Servername
This should return your current server name but if it
returns NULL then try:
Use Master
go
Sp_DropServer 'Server1'
GO
Use Master
go
Sp_Addserver 'Server1', 'local'
GO
Stop and Start SQL Services
If this is not the issue, but you are working across non-trusted doamins
there is the same error, so you might want to have a look at his article:
http://support.microsoft.com/?id=321822.
Regards,
Paul Ibison
|||I tried to run the sql, the servername is ok.
I read articale, but it seems not related to my problem, since I want to
setup the replication on a single machine.
Is it related to sql server agent? I am using system account as the startup
account in Sql server agent.
"Paul Ibison" <Paul.Ibison@.Pygmalion.Com> bl
news:Oocp%23YwKEHA.4052@.TK2MSFTNGP11.phx.gbl g...
> This is usually a naming issue.
> Try:
> Use Master
> go
> Select @.@.Servername
> This should return your current server name but if it
> returns NULL then try:
> Use Master
> go
> Sp_DropServer 'Server1'
> GO
> Use Master
> go
> Sp_Addserver 'Server1', 'local'
> GO
> Stop and Start SQL Services
> If this is not the issue, but you are working across non-trusted doamins
> there is the same error, so you might want to have a look at his article:
> http://support.microsoft.com/?id=321822.
> Regards,
> Paul Ibison
>
|||The system account is OK if it is all done on the same box.
You might be able to use sp_remoteoption and sp_addremotelogin to fix the
issue.
HTH,
Paul Ibison
|||can you remove replication, and then re-install it.
"gh" <ghghghgh@.FSAF.COM> wrote in message
news:uinEcarKEHA.1388@.TK2MSFTNGP09.phx.gbl...
> I want to setup a publisher, distributor and subscriber on the same
machine.
> While configuring my distributor using Wizard, I received the following
> error:
> Error 18483: Could not connect to server 'HONB" because
"distributor_admin"
> is not defined as a remote login at the server.
> I am using SQL Server Developer version and "HONB" is my computer name.
Can
> someone tell what I have mis-configed?
>
>
>

Error 18483 'distributor_admin'

I'm trying to publish a database and when I get to the end of the wizard, I
am greeted by this message:
SQL Server Enterprise Manager could not configure 'SERVERNAME' as the
Distributor for 'SERVERNAME'.
Error 18483: Could not connect to server 'SERVERNAME' because
'distributor_admin' is not defined as a remote login at the server.
The MS articles did not help me. Can someone, please?
Wack
This message will self destruct.
try to drop the server and then recreate it
sp_dropserver @.@.servername
GO
sp_addserver @.@.servername, 'local'
GO
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Ray Lewis" <dav5489@.hotmail.com> wrote in message
news:uO9gjUYJFHA.4060@.TK2MSFTNGP14.phx.gbl...
> I'm trying to publish a database and when I get to the end of the wizard,
I
> am greeted by this message:
> SQL Server Enterprise Manager could not configure 'SERVERNAME' as the
> Distributor for 'SERVERNAME'.
> Error 18483: Could not connect to server 'SERVERNAME' because
> 'distributor_admin' is not defined as a remote login at the server.
> The MS articles did not help me. Can someone, please?
> --
> Wack
> --
> This message will self destruct.
>
|||I tried this, and used MS article 818334. I found that the SQL Server Name
was not the same as the Computer Name. However, when I try and drop the SQL
server name, I get a message stating that the SQL server does not exist.
So, I cannot rename my SQL Server 2000 server. What now?
Wack
This message will self destruct.
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:uZUqNwaJFHA.1392@.TK2MSFTNGP10.phx.gbl...[vbcol=seagreen]
> try to drop the server and then recreate it
> sp_dropserver @.@.servername
> GO
> sp_addserver @.@.servername, 'local'
> GO
>
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
> "Ray Lewis" <dav5489@.hotmail.com> wrote in message
> news:uO9gjUYJFHA.4060@.TK2MSFTNGP14.phx.gbl...
wizard,
> I
>
|||Hi,
is the login used to configure the publication a member of the 'system administrators'? I had a similar problem when creating a pull subscription and this solved it!
Bruno

Quote:

Originally posted by Ray Lewis
I'm trying to publish a database and when I get to the end of the wizard, I
am greeted by this message:
SQL Server Enterprise Manager could not configure 'SERVERNAME' as the
Distributor for 'SERVERNAME'.
Error 18483: Could not connect to server 'SERVERNAME' because
'distributor_admin' is not defined as a remote login at the server.
The MS articles did not help me. Can someone, please?
Wack
This message will self destruct.

sql

error 18483 & 18482

Hi ,
At first i was trying to set up replication where i got the Error 18483:
could not connect to server 'SQL1; because 'distributor_admin' is not defined
as a remote login at the server.
as per some of the posting i used "Select @.@.Servername" (e.g SQL2)and found
that the name returned is not the same as the computer name(e.g SQL1)
so i executed sp_dropserver @.@.Servername (SQl2)
now when i tried to configure it as a publisher , it gives me "could not
configure SQL1 as the distributor for SQL1. error 18482 : could not connect
to SQL1 because 'SQL2' is not defined as a remote server
i have tried sp_addserver SQL1 but it does not work either
kindly advise
tks & rdgs
Message posted via droptable.com
http://www.droptable.com/Uwe/Forums...ation/200512/1
Hi ,
After i stop & start SQL Server , i got error 14114 : null is not
configured as a distributor and null is returned for select @.@.Servername
kindly advise
tks & rdgs
maxzsim wrote:
>Hi ,
> At first i was trying to set up replication where i got the Error 18483:
>could not connect to server 'SQL1; because 'distributor_admin' is not defined
>as a remote login at the server.
>as per some of the posting i used "Select @.@.Servername" (e.g SQL2)and found
>that the name returned is not the same as the computer name(e.g SQL1)
>so i executed sp_dropserver @.@.Servername (SQl2)
>now when i tried to configure it as a publisher , it gives me "could not
>configure SQL1 as the distributor for SQL1. error 18482 : could not connect
>to SQL1 because 'SQL2' is not defined as a remote server
>i have tried sp_addserver SQL1 but it does not work either
>kindly advise
>tks & rdgs
Message posted via droptable.com
http://www.droptable.com/Uwe/Forums...ation/200512/1
|||Hi,
The steps below from one of the posting works
sp_dropserver 'wrong server name'
sp_addserver 'correct server name'
stop & start sql services( i forgot to do this step earlier)
tks & rdgs
maxzsim wrote:[vbcol=seagreen]
>Hi ,
> After i stop & start SQL Server , i got error 14114 : null is not
>configured as a distributor and null is returned for select @.@.Servername
>kindly advise
>tks & rdgs
>[quoted text clipped - 16 lines]
Message posted via droptable.com
http://www.droptable.com/Uwe/Forums...ation/200512/1
|||Had similar problem with starting the replication distributor.
Got login failed message for distributor_admin user.
Problem: Local SQL Server instance name incorrect
We changed the name of the server a while back but the @.@.Servername had the
old server name.
Solution:
sp_dropserver 'oldservername'
sp_addserver 'newservername', @.local = 'local'
The @.local ='local' is required because the replication server is the local
server not a remote server.
Also you need to stop and restart SQL Server Agent.
"maxzsim via droptable.com" wrote:

> Hi,
> The steps below from one of the posting works
> sp_dropserver 'wrong server name'
> sp_addserver 'correct server name'
> stop & start sql services( i forgot to do this step earlier)
> tks & rdgs
>
> maxzsim wrote:
> --
> Message posted via droptable.com
> http://www.droptable.com/Uwe/Forums...ation/200512/1
>

Error 18456: Login failed for user 'DOMAIN\user'

Hi,
I've just installed SQL Server 2005 Beta 2 and added Active Directory
account to our SQL Server (under Database/Security/Logins). However, when I
try to login using the Windows Authentication, I get this error message:
Login failed for user 'DOMAIN\user'. (Microsoft SQL Server, Error: 18456)
where DOMAIN\user is really my domain-account, which I rather not publish.
When I try to login using 'sa' and SQL Server Authentication there is no
problem.
I've tried to find out what error 18456 is but no luck. Could anyone help me
please?
Cheers,
ChrisI take it that either no one has ever heard of this error or that is so
common that its in every FAQ. In the latter case, could someone please point
me to a FAQ with a solution...
Cheers,
Chris
"Christoffer" <christoffer@.nospam.com> wrote in message
news:%23alyI3zjEHA.536@.TK2MSFTNGP11.phx.gbl...
> Hi,
> I've just installed SQL Server 2005 Beta 2 and added Active Directory
> account to our SQL Server (under Database/Security/Logins). However, when
> I try to login using the Windows Authentication, I get this error message:
> Login failed for user 'DOMAIN\user'. (Microsoft SQL Server, Error: 18456)
> where DOMAIN\user is really my domain-account, which I rather not publish.
> When I try to login using 'sa' and SQL Server Authentication there is no
> problem.
> I've tried to find out what error 18456 is but no luck. Could anyone help
> me please?
> Cheers,
> Chris
>|||Error 18456 is "login failed for user xxx"...the error you
are getting. You have something incorrect with adding the
windows account to the logins or the permissions you have
set for the login. Try deleting the login and then try
adding it again. Make sure the login has access to whatever
database you have set up as the default database.
-Sue
On Tue, 31 Aug 2004 11:34:56 +0200, "Christoffer"
<christoffer@.nospam.com> wrote:

>Hi,
>I've just installed SQL Server 2005 Beta 2 and added Active Directory
>account to our SQL Server (under Database/Security/Logins). However, when I
>try to login using the Windows Authentication, I get this error message:
>Login failed for user 'DOMAIN\user'. (Microsoft SQL Server, Error: 18456)
>where DOMAIN\user is really my domain-account, which I rather not publish.
>When I try to login using 'sa' and SQL Server Authentication there is no
>problem.
>I've tried to find out what error 18456 is but no luck. Could anyone help m
e
>please?
>Cheers,
>Chris
>|||Hello
I deleted and re-added the account and I also gave it access to every
database with db_owner on every database. I also made the account a member
of the sysadmin role. Still no luck
The account is in a Active Directory, could this be the problem?
Cheers,
Chris
"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
news:9rlpj0982j03evgpta2vla52c2jrtlg9md@.
4ax.com...
> Error 18456 is "login failed for user xxx"...the error you
> are getting. You have something incorrect with adding the
> windows account to the logins or the permissions you have
> set for the login. Try deleting the login and then try
> adding it again. Make sure the login has access to whatever
> database you have set up as the default database.
> -Sue
> On Tue, 31 Aug 2004 11:34:56 +0200, "Christoffer"
> <christoffer@.nospam.com> wrote:
>
>|||Are you a member of a group that has been denied access to
the server? Did you try another Windows account and test
with that?
-Sue
On Tue, 7 Sep 2004 14:53:32 +0200, "Christoffer"
<christoffer@.nospam.com> wrote:

>Hello
>I deleted and re-added the account and I also gave it access to every
>database with db_owner on every database. I also made the account a member
>of the sysadmin role. Still no luck
>The account is in a Active Directory, could this be the problem?
>Cheers,
>Chris
>"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
> news:9rlpj0982j03evgpta2vla52c2jrtlg9md@.
4ax.com...
>|||Hello,
I think I have found the problem. When I add my login (DOMAIN\USER) using
the Microsoft SQL Server Management Studio (2005 Beta 2), the property
"Server Access" is set to "Via Group Membership". If I change this to
"Permit" I can login!
My question is: What is "Via Group Membership" and is this the best practice
when adding Windows logins?
Thanks,
Chris
"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
news:90psj0p1dethn063mh6sd61u9fi93c1ec9@.
4ax.com...
> Are you a member of a group that has been denied access to
> the server? Did you try another Windows account and test
> with that?
> -Sue
> On Tue, 7 Sep 2004 14:53:32 +0200, "Christoffer"
> <christoffer@.nospam.com> wrote:
>
>|||Via group membership means the login was has access to SQL
Server through their membership in a windows group.
Managing logins through windows group can definitely make
the management of logins much easier.
-Sue
On Wed, 8 Sep 2004 10:31:06 +0200, "Christoffer"
<christoffer@.nospam.com> wrote:

>Hello,
>I think I have found the problem. When I add my login (DOMAIN\USER) using
>the Microsoft SQL Server Management Studio (2005 Beta 2), the property
>"Server Access" is set to "Via Group Membership". If I change this to
>"Permit" I can login!
>My question is: What is "Via Group Membership" and is this the best practic
e
>when adding Windows logins?
>Thanks,
>Chris
>
>"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
> news:90psj0p1dethn063mh6sd61u9fi93c1ec9@.
4ax.com...
>|||I see, the thing is, there is no added Windows groups login in the SQL
Server. I tried adding DOMAIN\Administrators but I got the errore message:
"The login 'DOMAIN\Administrators' does not exist. (Microsoft SQL Server,
Error: 15007)"
But I'm sure it exists since I browsed to it using the Active Directory. Is
there some limitation to adding the DOMAIN\Administrators group? Should I
try to set up yet another group for database access?
Thanks for your help!
/Chris
"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
news:8pttj05a5jihmdoqe1ekg4iufo7er08j5f@.
4ax.com...
> Via group membership means the login was has access to SQL
> Server through their membership in a windows group.
> Managing logins through windows group can definitely make
> the management of logins much easier.
> -Sue
> On Wed, 8 Sep 2004 10:31:06 +0200, "Christoffer"
> <christoffer@.nospam.com> wrote:
>
>|||Chris,
I'm not real clear on when you are receiving this error. It doesn't
look like something you would get when you actually try to add the
login. Try add the account using Query Analyzer instead and executing
sp_grantlogin. The help file has more information on sp_grantlogin.
Whether you set up another group or not depends upon how you are going
to design your security model. Using Windows groups certainly can be
easier but whether that works for you or not depends on how your
windows groups are set up, how well they reflect the access, security
needs of the applications that will use the databases on the server,
etc.
-Sue
On Wed, 8 Sep 2004 14:21:49 +0200, "Christoffer"
<christoffer@.nospam.com> wrote:

>I see, the thing is, there is no added Windows groups login in the SQL
>Server. I tried adding DOMAIN\Administrators but I got the errore message:
>"The login 'DOMAIN\Administrators' does not exist. (Microsoft SQL Server,
>Error: 15007)"
>But I'm sure it exists since I browsed to it using the Active Directory. Is
>there some limitation to adding the DOMAIN\Administrators group? Should I
>try to set up yet another group for database access?
>Thanks for your help!
>/Chris
>
>"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
> news:8pttj05a5jihmdoqe1ekg4iufo7er08j5f@.
4ax.com...
>|||Hi,
When I use the Microsoft SQL Server Management Studio, which is in SQL
Server 2005 and is equivalent to Enterprise Manager for SQL Server 2000, to
add a Windows login, the login's Server access property is set to "Via group
membership".
If I use the stored procedures sp_grantlogin on SQL Server 2005, the login's
Server access property is set to "Permit".
If I use the old Enterprise Manager for SQL Server 2000, the login's Server
access property is set to "Permit".
Why does the SQL Server Management Studio (2005) set the Server access
property to "Via group membership" instead of "Permit". I know this is a
beta and an answer might not be possible to give...
Thanks for helping me out, I no longer experience the 18456 error, this is
just out of curiousity
/Chris
"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
news:iq7uj0tv8g78vlco9b6dr4m36uq1b3n1tc@.
4ax.com...
> Chris,
> I'm not real clear on when you are receiving this error. It doesn't
> look like something you would get when you actually try to add the
> login. Try add the account using Query Analyzer instead and executing
> sp_grantlogin. The help file has more information on sp_grantlogin.
> Whether you set up another group or not depends upon how you are going
> to design your security model. Using Windows groups certainly can be
> easier but whether that works for you or not depends on how your
> windows groups are set up, how well they reflect the access, security
> needs of the applications that will use the databases on the server,
> etc.
> -Sue
> On Wed, 8 Sep 2004 14:21:49 +0200, "Christoffer"
> <christoffer@.nospam.com> wrote:
>
>

Error 18456: Login failed for user 'Distributor_admin'

Hi,
When going through the replication wizard to setup transactional replication
the following error is returned when it starts to setup replication.
SQL Server Enterprise Manager could not configure '<four part servername>'
as the distributor for '<four part servername>'
Error 18456: Login failed for user 'Distributor_admin'
Can someone please help. Is it because of the four part server name?
Thanks
It could be. What happens when you create an alias using the client network
utility. After doing this de-register your server in EM, and then reregister
it with the new one part alias.
Is the distributor local?
"mm" <postto@.news.com> wrote in message
news:eIM2gdb$EHA.2196@.TK2MSFTNGP14.phx.gbl...
> Hi,
> When going through the replication wizard to setup transactional
> replication
> the following error is returned when it starts to setup replication.
> SQL Server Enterprise Manager could not configure '<four part servername>'
> as the distributor for '<four part servername>'
> Error 18456: Login failed for user 'Distributor_admin'
>
> Can someone please help. Is it because of the four part server name?
> Thanks
>
>
|||Hi Hilary,
There is no alisa defined in the the client network utility.
This happens when trying to setup a local distributor. However there is a
database on the SQL server that subscribes to a remote distributor.
Thanks
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:eiLeJZi$EHA.3472@.TK2MSFTNGP14.phx.gbl...
> It could be. What happens when you create an alias using the client
network
> utility. After doing this de-register your server in EM, and then
reregister[vbcol=seagreen]
> it with the new one part alias.
> Is the distributor local?
>
> "mm" <postto@.news.com> wrote in message
> news:eIM2gdb$EHA.2196@.TK2MSFTNGP14.phx.gbl...
servername>'
>

Error 18456, State 28000

Hello,
Running SQL Server 2000... I've installed a new instance of this on a new
server (to migrate from server1 to server2).
On server1, i have a group set up (domain/SQLGroup)...
On server2, i have the exact same group set up... unfortunately all the
users in this group doesn't get recognized by my new sql installation. I
get the error above (SQL Error 18456, State '28000')..
I can change permissions for all the users in this group to have "Domain
Admins", but obviously i don't want to do that... by doing this though, all
access works as before...
SP4 is installed on server2, but not on server1...
Does anyone have any suggestions on how to proceed with this?
Thanks.One thing i should add about this...
Server1 is the Domain Controller...running sbs2000 (windows 2000 server).
Server2 is just windows 2003, and is dedicated to sql server 2000...
Thanks,
...Robin
"RL Tech" <tech_support@.nospamuls.com> wrote in message
news:u1nxZaSUGHA.4952@.TK2MSFTNGP09.phx.gbl...
> Hello,
> Running SQL Server 2000... I've installed a new instance of this on a new
> server (to migrate from server1 to server2).
> On server1, i have a group set up (domain/SQLGroup)...
> On server2, i have the exact same group set up... unfortunately all the
> users in this group doesn't get recognized by my new sql installation. I
> get the error above (SQL Error 18456, State '28000')..
> I can change permissions for all the users in this group to have "Domain
> Admins", but obviously i don't want to do that... by doing this though,
all
> access works as before...
> SP4 is installed on server2, but not on server1...
> Does anyone have any suggestions on how to proceed with this?
> Thanks.
>

Error 18456" error message when you specify configuration database

I appreciate if some one please help me to solve the following problem
SYMPTOMS
I am runnning the Setup program to install Microsoft Windows SharePoint
Services. After the Setup program is completed successfully, I configure
Windows SharePoint Services settings in SharePoint Central Administration. I
then specify configuration database settings on the Set Configuration
Database Server page of SharePoint Central Administration, and then I click
OK. Then, I receive one of the following error messages:
"Error 18456" error message when you specify configuration database settings
on the Set Configuration Database Server page of SharePoint Central
Administrator"
I have gone through the article on
http://support.microsoft.com/?kbid=889646&FR=1 but it does not help me out.
Please let me know if some one came across this problem & i could solve it
with your support
Thanks in advance
Regards
Error 18456
Severity Level 14
Message Text
Login failed for user '%ls'.
Make sure that the user you specified is correct and has the correct password.
Regards
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Yakoob" wrote:

> I appreciate if some one please help me to solve the following problem
>
> SYMPTOMS
> I am runnning the Setup program to install Microsoft Windows SharePoint
> Services. After the Setup program is completed successfully, I configure
> Windows SharePoint Services settings in SharePoint Central Administration. I
> then specify configuration database settings on the Set Configuration
> Database Server page of SharePoint Central Administration, and then I click
> OK. Then, I receive one of the following error messages:
> "Error 18456" error message when you specify configuration database settings
> on the Set Configuration Database Server page of SharePoint Central
> Administrator"
> I have gone through the article on
> http://support.microsoft.com/?kbid=889646&FR=1 but it does not help me out.
> Please let me know if some one came across this problem & i could solve it
> with your support
> Thanks in advance
> Regards

Error 18456" error message when you specify configuration database

I appreciate if some one please help me to solve the following problem
SYMPTOMS
I am runnning the Setup program to install Microsoft Windows SharePoint
Services. After the Setup program is completed successfully, I configure
Windows SharePoint Services settings in SharePoint Central Administration. I
then specify configuration database settings on the Set Configuration
Database Server page of SharePoint Central Administration, and then I click
OK. Then, I receive one of the following error messages:
"Error 18456" error message when you specify configuration database settings
on the Set Configuration Database Server page of SharePoint Central
Administrator"
I have gone through the article on
http://support.microsoft.com/?kbid=889646&FR=1 but it does not help me out.
Please let me know if some one came across this problem & i could solve it
with your support
Thanks in advance
RegardsError 18456
Severity Level 14
Message Text
Login failed for user '%ls'.
Make sure that the user you specified is correct and has the correct password.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Yakoob" wrote:
> I appreciate if some one please help me to solve the following problem
>
> SYMPTOMS
> I am runnning the Setup program to install Microsoft Windows SharePoint
> Services. After the Setup program is completed successfully, I configure
> Windows SharePoint Services settings in SharePoint Central Administration. I
> then specify configuration database settings on the Set Configuration
> Database Server page of SharePoint Central Administration, and then I click
> OK. Then, I receive one of the following error messages:
> "Error 18456" error message when you specify configuration database settings
> on the Set Configuration Database Server page of SharePoint Central
> Administrator"
> I have gone through the article on
> http://support.microsoft.com/?kbid=889646&FR=1 but it does not help me out.
> Please let me know if some one came across this problem & i could solve it
> with your support
> Thanks in advance
> Regards|||Here it is not asking for any user, In database connection type, i have using
the option "user windows authentication" so i dont know which account its
going to use here to create the database.
Please help me out
Thanks
"Mike Epprecht (SQL MVP)" wrote:
> Error 18456
> Severity Level 14
> Message Text
> Login failed for user '%ls'.
>
> Make sure that the user you specified is correct and has the correct password.
> Regards
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
>
> "Yakoob" wrote:
> > I appreciate if some one please help me to solve the following problem
> >
> >
> > SYMPTOMS
> >
> > I am runnning the Setup program to install Microsoft Windows SharePoint
> > Services. After the Setup program is completed successfully, I configure
> > Windows SharePoint Services settings in SharePoint Central Administration. I
> > then specify configuration database settings on the Set Configuration
> > Database Server page of SharePoint Central Administration, and then I click
> > OK. Then, I receive one of the following error messages:
> > "Error 18456" error message when you specify configuration database settings
> > on the Set Configuration Database Server page of SharePoint Central
> > Administrator"
> >
> > I have gone through the article on
> > http://support.microsoft.com/?kbid=889646&FR=1 but it does not help me out.
> > Please let me know if some one came across this problem & i could solve it
> > with your support
> > Thanks in advance
> > Regards|||It's probably [NT AUTHORITY\NETWORK SERVICE]. You should be able to see the
error in the SQL Error log (Open SQL Enterprise Manager and connect to the
SQL Server instance in question and navigate to Management>SQL Server Logs)
--
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Yakoob" <Yakoob@.discussions.microsoft.com> wrote in message
news:D91EF3D6-7AE4-4707-9F60-FEEFB797B771@.microsoft.com...
> Here it is not asking for any user, In database connection type, i have
> using
> the option "user windows authentication" so i dont know which account its
> going to use here to create the database.
> Please help me out
> Thanks
> "Mike Epprecht (SQL MVP)" wrote:
>> Error 18456
>> Severity Level 14
>> Message Text
>> Login failed for user '%ls'.
>>
>> Make sure that the user you specified is correct and has the correct
>> password.
>> Regards
>> --
>> Mike Epprecht, Microsoft SQL Server MVP
>> Zurich, Switzerland
>> MVP Program: http://www.microsoft.com/mvp
>> Blog: http://www.msmvps.com/epprecht/
>>
>> "Yakoob" wrote:
>> > I appreciate if some one please help me to solve the following problem
>> >
>> >
>> > SYMPTOMS
>> >
>> > I am runnning the Setup program to install Microsoft Windows SharePoint
>> > Services. After the Setup program is completed successfully, I
>> > configure
>> > Windows SharePoint Services settings in SharePoint Central
>> > Administration. I
>> > then specify configuration database settings on the Set Configuration
>> > Database Server page of SharePoint Central Administration, and then I
>> > click
>> > OK. Then, I receive one of the following error messages:
>> > "Error 18456" error message when you specify configuration database
>> > settings
>> > on the Set Configuration Database Server page of SharePoint Central
>> > Administrator"
>> >
>> > I have gone through the article on
>> > http://support.microsoft.com/?kbid=889646&FR=1 but it does not help me
>> > out.
>> > Please let me know if some one came across this problem & i could solve
>> > it
>> > with your support
>> > Thanks in advance
>> > Regards|||Thanks for your reply, yes i understand that it iw using NT AUTHORITY\NETWORK
SERVICE, but even this i didn't find in SQL server logs as you have
mentioned. If i have to check for correct password then where? because i am
not providing here any password during "set configuration database server". I
am selecting the following options which is mandatory as per installation
guide for MS project 2003 server.
1. Database server = "i give sql server name"
2. SQL server database name = "database name as sharepointdb"
3. selected the option "use windows authentication
4. then last option " users already have domain accounts. Do not creat
active directory accounts.
I dont see any NT AUTHORITY account in active directory to give permission
for database create or to see for its password, please let me know
Thanks & Regards
"Jasper Smith" wrote:
> It's probably [NT AUTHORITY\NETWORK SERVICE]. You should be able to see the
> error in the SQL Error log (Open SQL Enterprise Manager and connect to the
> SQL Server instance in question and navigate to Management>SQL Server Logs)
> --
> HTH
> Jasper Smith (SQL Server MVP)
> http://www.sqldbatips.com
> I support PASS - the definitive, global
> community for SQL Server professionals -
> http://www.sqlpass.org
> "Yakoob" <Yakoob@.discussions.microsoft.com> wrote in message
> news:D91EF3D6-7AE4-4707-9F60-FEEFB797B771@.microsoft.com...
> > Here it is not asking for any user, In database connection type, i have
> > using
> > the option "user windows authentication" so i dont know which account its
> > going to use here to create the database.
> > Please help me out
> >
> > Thanks
> >
> > "Mike Epprecht (SQL MVP)" wrote:
> >
> >> Error 18456
> >> Severity Level 14
> >> Message Text
> >> Login failed for user '%ls'.
> >>
> >>
> >> Make sure that the user you specified is correct and has the correct
> >> password.
> >>
> >> Regards
> >> --
> >> Mike Epprecht, Microsoft SQL Server MVP
> >> Zurich, Switzerland
> >>
> >> MVP Program: http://www.microsoft.com/mvp
> >>
> >> Blog: http://www.msmvps.com/epprecht/
> >>
> >>
> >>
> >> "Yakoob" wrote:
> >>
> >> > I appreciate if some one please help me to solve the following problem
> >> >
> >> >
> >> > SYMPTOMS
> >> >
> >> > I am runnning the Setup program to install Microsoft Windows SharePoint
> >> > Services. After the Setup program is completed successfully, I
> >> > configure
> >> > Windows SharePoint Services settings in SharePoint Central
> >> > Administration. I
> >> > then specify configuration database settings on the Set Configuration
> >> > Database Server page of SharePoint Central Administration, and then I
> >> > click
> >> > OK. Then, I receive one of the following error messages:
> >> > "Error 18456" error message when you specify configuration database
> >> > settings
> >> > on the Set Configuration Database Server page of SharePoint Central
> >> > Administrator"
> >> >
> >> > I have gone through the article on
> >> > http://support.microsoft.com/?kbid=889646&FR=1 but it does not help me
> >> > out.
> >> > Please let me know if some one came across this problem & i could solve
> >> > it
> >> > with your support
> >> > Thanks in advance
> >> > Regards
>
>

Error 18456" error message when you specify configuration database

I appreciate if some one please help me to solve the following problem
SYMPTOMS
I am runnning the Setup program to install Microsoft Windows SharePoint
Services. After the Setup program is completed successfully, I configure
Windows SharePoint Services settings in SharePoint Central Administration. I
then specify configuration database settings on the Set Configuration
Database Server page of SharePoint Central Administration, and then I click
OK. Then, I receive one of the following error messages:
"Error 18456" error message when you specify configuration database settings
on the Set Configuration Database Server page of SharePoint Central
Administrator"
I have gone through the article on
http://support.microsoft.com/?kbid=889646&FR=1 but it does not help me out.
Please let me know if some one came across this problem & i could solve it
with your support
Thanks in advance
RegardsError 18456
Severity Level 14
Message Text
Login failed for user '%ls'.
Make sure that the user you specified is correct and has the correct passwor
d.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Yakoob" wrote:

> I appreciate if some one please help me to solve the following problem
>
> SYMPTOMS
> I am runnning the Setup program to install Microsoft Windows SharePoint
> Services. After the Setup program is completed successfully, I configure
> Windows SharePoint Services settings in SharePoint Central Administration.
I
> then specify configuration database settings on the Set Configuration
> Database Server page of SharePoint Central Administration, and then I clic
k
> OK. Then, I receive one of the following error messages:
> "Error 18456" error message when you specify configuration database settin
gs
> on the Set Configuration Database Server page of SharePoint Central
> Administrator"
> I have gone through the article on
> http://support.microsoft.com/?kbid=889646&FR=1 but it does not help me out
.
> Please let me know if some one came across this problem & i could solve it
> with your support
> Thanks in advance
> Regardssql

Error 18456 with logon using Windows accounts

Hi,
I've installed SQL 2000 SP3 on a Windows 2000 server with Active Directory (not the PDC), but when I try to logon using a Windows account (domain\user) I get the following error:
Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.
SQL State: 28000
DB error: 18456
The same happens when I try to logon with the Query Analyzer or register the server in Enterprise Manager. I looked around other forums to figure this one out but none of the tips there worked:
- Authentication is mixed mode
- IIS is not installed
- There is a login created in SQL for the Windows user

Any idea's?In the back of my mind somewhere, I have a recollection that when AD is installed the Local Users for that server are disabled. Was the user you were trying to log in as Local or Domain?

I think I would try creating a Domain User, adding that user into the Local Computer Administrators group and then logging in as that Domain User.

Regards,

Hugh Scott

Originally posted by dbJeff
Hi,
I've installed SQL 2000 SP3 on a Windows 2000 server with Active Directory (not the PDC), but when I try to logon using a Windows account (domain\user) I get the following error:
Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.
SQL State: 28000
DB error: 18456
The same happens when I try to logon with the Query Analyzer or register the server in Enterprise Manager. I looked around other forums to figure this one out but none of the tips there worked:
- Authentication is mixed mode
- IIS is not installed
- There is a login created in SQL for the Windows user

Any idea's?|||Hugh, you're right that Local Users are disabled with AD, but Local Groups are as well. Any other idea's?

Originally posted by hmscott
In the back of my mind somewhere, I have a recollection that when AD is installed the Local Users for that server are disabled. Was the user you were trying to log in as Local or Domain?

I think I would try creating a Domain User, adding that user into the Local Computer Administrators group and then logging in as that Domain User.

Regards,

Hugh Scott|||D'oh! That wasn't very smart of me!

Did you try using sp_grantaccess to ensure that the domain account you were trying to use can access the server?

I don't have much experience running SQL Server with AD; I am running a home network with AD and SQL running on the PDC. I am authenticating using a local account on my Windows XP notebook with no problems. Before I promoted the server to DC, I had a local account with identical credentials in the Administrators group. I have had no problems keeping that account up and running.

I'm afraid I don't have many other suggestions...sorry.

Regards,

Hugh

Originally posted by dbJeff
Hugh, you're right that Local Users are disabled with AD, but Local Groups are as well. Any other idea's?

error 18456 when trying to connect to 2005 using odbc

Hi all

I am using Windows XP SP2 with a Sql server 2005 Express installation. I created a test db with a user called test, schema also test. I gave the permission connect, db_datareader and db_datawriter. I can now connect into this user using WinSQL. But if I want to connect using a application which is using ODBC, then I get the error:

[SQLSTATE=28000 - [Microsoft][SQL Native][SQL Server]Login failed for user 'test'.[Native Error=18456]]

Because I connect using ODBC, I think there must be the problem. But I have to connect with ODBC. There is no other possibility.

any ideas ?

Regards, Waff

I found this out:

The server collation is defined to: Latin1_General_CI_AS

If I create a new login id in lowercase, then ODBC will change it to uppercase and then the server refuse the access. But why. CI means case insensitive, so doesn't matter if upper or lower case. should.

How do you use a id in lowercase and connecto via ODBC ?

You need to enable TCP in order for ODBC clients to connect. Check out http://blogs.msdn.com/sqlexpress/archive/2004/07/23/192044.aspx for information about doing this.

Mike

|||

Guess has something to do with the collation. I used Latin1_General_AI_CI.

If I create my login id in lowercase and try then to connect to the db using ODBC, then ODBC will switch my id to uppercase and so I can't logon.

Anyway, somehow, it must be possible to modify the server settings, so that it doesn't matter how I logon. lowercase or uppercase. I tryed with CI and CS but still them same.

ODBC is enabled but think has to do with the collation.

What are you using if you use id's as upper/lower case as Test ?

error 18456 when trying to connect to 2005 using odbc

Hi all

I am using Windows XP SP2 with a Sql server 2005 Express installation. I created a test db with a user called test, schema also test. I gave the permission connect, db_datareader and db_datawriter. I can now connect into this user using WinSQL. But if I want to connect using a application which is using ODBC, then I get the error:

[SQLSTATE=28000 - [Microsoft][SQL Native][SQL Server]Login failed for user 'test'.[Native Error=18456]]

Because I connect using ODBC, I think there must be the problem. But I have to connect with ODBC. There is no other possibility.

any ideas ?

Regards, Waff

I found this out:

The server collation is defined to: Latin1_General_CI_AS

If I create a new login id in lowercase, then ODBC will change it to uppercase and then the server refuse the access. But why. CI means case insensitive, so doesn't matter if upper or lower case. should.

How do you use a id in lowercase and connecto via ODBC ?

You need to enable TCP in order for ODBC clients to connect. Check out http://blogs.msdn.com/sqlexpress/archive/2004/07/23/192044.aspx for information about doing this.

Mike

|||

Guess has something to do with the collation. I used Latin1_General_AI_CI.

If I create my login id in lowercase and try then to connect to the db using ODBC, then ODBC will switch my id to uppercase and so I can't logon.

Anyway, somehow, it must be possible to modify the server settings, so that it doesn't matter how I logon. lowercase or uppercase. I tryed with CI and CS but still them same.

ODBC is enabled but think has to do with the collation.

What are you using if you use id's as upper/lower case as Test ?

error 18456 when running job

sql2k sp3
Ive got a job that creates a folder both on the local box
and on the remote box. This job has run every nite
successfully for a few weeks now. Last nite it failed with
message: Login failed for user 'NT AUTHORITY\ANONYMOUS
LOGON'. [SQLSTATE 28000] (Error 18456). The step failed.
I havent changed anything security or services related.
The sql services for both boxes run in the same domain
admin account.
Any ideas?
Thanks, Chris.Try making the job owner sa. I've seen this and it ideespeared when I did that.
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as ugroup=microsoft.public.sqlserver
"chris" <chrisr@.fingps.com> wrote in message news:034901c36693$a4ce8750$a501280a@.phx.gbl...
> sql2k sp3
> Ive got a job that creates a folder both on the local box
> and on the remote box. This job has run every nite
> successfully for a few weeks now. Last nite it failed with
> message: Login failed for user 'NT AUTHORITY\ANONYMOUS
> LOGON'. [SQLSTATE 28000] (Error 18456). The step failed.
> I havent changed anything security or services related.
> The sql services for both boxes run in the same domain
> admin account.
> Any ideas?
> Thanks, Chris.

Error 18456 State 6

Hi,

I am trying to connect to a remote SQL server via Management Studio. I am using the windows credentials I use to log into the computer but when I enter the same domain\username and password I get error 18456. I check the logs and see it is a state 6 error. After checking http://blogs.msdn.com/sql_protocols/archive/2006/02/21/536201.aspx I see that means

Attempt to use a Windows login name with SQL Authentication

Is it possible for me to access a SQL server remotely?

Thanks

From your description, I would assume that you chose “SQL Server Authentication” and provided a user name that was a Windows user name, correct? “SQL Server Authentication” is used only for principals whose information is completely under the control of the SQL Server instance (i.e. the SID, login and password are only valid to SQL Server).

When using Windows authentication the server will use the Windows token from your client program (in this case Management Studio) to authenticate the connection, without the need to type any login or password.

When you connect to SQL Server using Management Studio, make sure you choose the option “Windows Authentication” for the “Authentication” value, the user name and password fields should be grayed out.

I hope this helps, but let us know if you still have any questions.

-Raul Garcia

SDE/T

SQL Server Engine

sql

Error 18456 Severity: 14 State 11 problem

I am installing diskeeper administrator on one server with at database on our sql2005 server. When I am trying to connect to the database the diskeeper software says verify username and password. I try to connect using windows authentication .And in the serverlog this error occurs

2006-11-27 15:04:56.01 Logon Login failed for user 'NB\Servername$'. [CLIENT: "Ipadress"]

2006-11-27 15:04:56.01 Logon Error: 18456, Severity: 14, State: 11.

When i try to connect with Sql server authentication, this error occurs in the log:

2006-11-27 15:48:35.46 Logon Login failed for user 'NB\SERVERNAME$'. [CLIENT: ipadress

]2006-11-27 16:04:22.94 Logon Error: 18456, Severity: 14, State: 16.

I have tried to disable filesharing, and run installation of diskeepper as the domain administrator. But the same error occurs.

Can anyone help me with this

Regards Oyvind

State 11 indicates an error determining the database to be used after authentication. This could happen if the database cannot be accessed for some reason. You could try to connect to the master database initially, to see if that works, then change context to the database that you normally use and see what error you encounter, if any.

However, I am not familiar with the diskeeper software and I don't understand its relation with SQL Server, so I'm not sure how to help you further.

Thanks
Laurentiu

|||

Diskeeper do not have any link with SQL Server in this case, and also it is no use in running for linked server related error.

What is the privilege for the account used on the linked server?

Refer to KBA http://support.microsoft.com/kb/889646 fyi.

|||

The privilege for the account is sysadmin.

The default database is master.

I also tried to connect with odbc, but the same error occurs

Regards

Oyvind

|||have you contacted the vendor in this case?|||

Correction to my previous post: the state discussion applies to state 16, not to state 11.

State 11 indicates a different problem.

What is strange is that, while you mention using Windows and SQL authentication, both connections appear to be attempted via Windows authentication, using the machine account credentials.

Best thing would be to check with the diskeeper customer support.