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 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, 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 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 18452

I have a co-worker who installed SQL Server 2000 on her
machine. For some reason, when she tries to connect to
Query Analyzer using SQL Server authentication she gets
error 18452 (Login failed for user 'sa'. Reason: Not
associated with a trusted SQL Server connection.).
I don't know exactly how she installed SQL Server 2000,
but the only way for her to connect right now is by
windows authentication, which is what's recommended.
Anyways, I would like to know how can one resolve this
issue.
Thanks in advance,
BdeeTo change the Authentication mode for the server via Enterprise Manager,
Right click on the Server and choose Properties. Goto the security Tab in
the dialog and select the SQL Server and Windows radio button in the
Authentication section and click ok. You will need to restart the SQL
service for this to take effect
HTH
Jasper Smith (SQL Server MVP)
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"bd" <anonymous@.discussions.microsoft.com> wrote in message
news:d6d301c439f9$0a6de270$a301280a@.phx.gbl...
> I have a co-worker who installed SQL Server 2000 on her
> machine. For some reason, when she tries to connect to
> Query Analyzer using SQL Server authentication she gets
> error 18452 (Login failed for user 'sa'. Reason: Not
> associated with a trusted SQL Server connection.).
> I don't know exactly how she installed SQL Server 2000,
> but the only way for her to connect right now is by
> windows authentication, which is what's recommended.
> Anyways, I would like to know how can one resolve this
> issue.
> Thanks in advance,
> Bdee

Error 18452

I have a co-worker who installed SQL Server 2000 on her
machine. For some reason, when she tries to connect to
Query Analyzer using SQL Server authentication she gets
error 18452 (Login failed for user 'sa'. Reason: Not
associated with a trusted SQL Server connection.).
I don't know exactly how she installed SQL Server 2000,
but the only way for her to connect right now is by
windows authentication, which is what's recommended.
Anyways, I would like to know how can one resolve this
issue.
Thanks in advance,
BdeeTo change the Authentication mode for the server via Enterprise Manager,
Right click on the Server and choose Properties. Goto the security Tab in
the dialog and select the SQL Server and Windows radio button in the
Authentication section and click ok. You will need to restart the SQL
service for this to take effect
--
HTH
Jasper Smith (SQL Server MVP)
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"bd" <anonymous@.discussions.microsoft.com> wrote in message
news:d6d301c439f9$0a6de270$a301280a@.phx.gbl...
> I have a co-worker who installed SQL Server 2000 on her
> machine. For some reason, when she tries to connect to
> Query Analyzer using SQL Server authentication she gets
> error 18452 (Login failed for user 'sa'. Reason: Not
> associated with a trusted SQL Server connection.).
> I don't know exactly how she installed SQL Server 2000,
> but the only way for her to connect right now is by
> windows authentication, which is what's recommended.
> Anyways, I would like to know how can one resolve this
> issue.
> Thanks in advance,
> Bdee

Error 18452

I have a co-worker who installed SQL Server 2000 on her
machine. For some reason, when she tries to connect to
Query Analyzer using SQL Server authentication she gets
error 18452 (Login failed for user 'sa'. Reason: Not
associated with a trusted SQL Server connection.).
I don't know exactly how she installed SQL Server 2000,
but the only way for her to connect right now is by
windows authentication, which is what's recommended.
Anyways, I would like to know how can one resolve this
issue.
Thanks in advance,
Bdee
To change the Authentication mode for the server via Enterprise Manager,
Right click on the Server and choose Properties. Goto the security Tab in
the dialog and select the SQL Server and Windows radio button in the
Authentication section and click ok. You will need to restart the SQL
service for this to take effect
HTH
Jasper Smith (SQL Server MVP)
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"bd" <anonymous@.discussions.microsoft.com> wrote in message
news:d6d301c439f9$0a6de270$a301280a@.phx.gbl...
> I have a co-worker who installed SQL Server 2000 on her
> machine. For some reason, when she tries to connect to
> Query Analyzer using SQL Server authentication she gets
> error 18452 (Login failed for user 'sa'. Reason: Not
> associated with a trusted SQL Server connection.).
> I don't know exactly how she installed SQL Server 2000,
> but the only way for her to connect right now is by
> windows authentication, which is what's recommended.
> Anyways, I would like to know how can one resolve this
> issue.
> Thanks in advance,
> Bdee
sql

Error 1612 - can't get Express installed

I have done all I can to resolve this on my own and would really appreciate any help anyone can give me. I have run uninstall utilities, followed a few MSDN reinstall methods, but all roads lead back to this vicious cycle:

The install hangs trying to install the prereq Microsoft SQL Server 2005 Setup Support Files with Error 1612. So I try to uninstall the Support files using Add/Remove..but the Windows Installer looks for "Microsoft SQL Server Native Client" disk, which of course I don't have because I install from downloads from Microsoft.

That's the very short version. I've got a ton of hours reading help groups, MSDN, trying everything.

I have posted the error log file below. Thanks in advance.

=== Verbose logging started: 1/25/2007 21:01:41 Build type: SHIP UNICODE 3.01.4000.2435 Calling process: c:\6b4bf5519a6c349936f69599\setup.exe ===
MSI (c) (2C:64) [21:01:41:265]: Resetting cached policy values
MSI (c) (2C:64) [21:01:41:265]: Machine policy value 'Debug' is 0
MSI (c) (2C:64) [21:01:41:265]: ******* RunEngine:
******* Product: {53F5C3EE-05ED-4830-994B-50B2F0D50FCE}
******* Action:
******* CommandLine: **********
MSI (c) (2C:64) [21:01:41:265]: Client-side and UI is none or basic: Running entire install on the server.
MSI (c) (2C:64) [21:01:41:265]: Grabbed execution mutex.
MSI (c) (2C:64) [21:01:41:281]: Cloaking enabled.
MSI (c) (2C:64) [21:01:41:281]: Attempting to enable all disabled priveleges before calling Install on Server
MSI (c) (2C:64) [21:01:41:281]: Incrementing counter to disable shutdown. Counter after increment: 0
MSI (s) (98:90) [21:01:41:296]: Grabbed execution mutex.
MSI (s) (98:E4) [21:01:41:296]: Resetting cached policy values
MSI (s) (98:E4) [21:01:41:296]: Machine policy value 'Debug' is 0
MSI (s) (98:E4) [21:01:41:296]: ******* RunEngine:
******* Product: {53F5C3EE-05ED-4830-994B-50B2F0D50FCE}
******* Action:
******* CommandLine: **********
MSI (s) (98:E4) [21:01:41:296]: Machine policy value 'DisableUserInstalls' is 0
MSI (s) (98:E4) [21:01:41:296]: User policy value 'SearchOrder' is 'nmu'
MSI (s) (98:E4) [21:01:41:296]: User policy value 'DisableMedia' is 0
MSI (s) (98:E4) [21:01:41:296]: Machine policy value 'AllowLockdownMedia' is 0
MSI (s) (98:E4) [21:01:41:296]: SOURCEMGMT: Media enabled only if package is safe.
MSI (s) (98:E4) [21:01:41:296]: SOURCEMGMT: Looking for sourcelist for product {53F5C3EE-05ED-4830-994B-50B2F0D50FCE}
MSI (s) (98:E4) [21:01:41:296]: SOURCEMGMT: Adding {53F5C3EE-05ED-4830-994B-50B2F0D50FCE}; to potential sourcelist list (pcode;disk;relpath).
MSI (s) (98:E4) [21:01:41:296]: SOURCEMGMT: Now checking product {53F5C3EE-05ED-4830-994B-50B2F0D50FCE}
MSI (s) (98:E4) [21:01:41:296]: SOURCEMGMT: Media is enabled for product.
MSI (s) (98:E4) [21:01:41:296]: SOURCEMGMT: Attempting to use LastUsedSource from source list.
MSI (s) (98:E4) [21:01:41:296]: SOURCEMGMT: Source with value name '1' is blank
MSI (s) (98:E4) [21:01:41:296]: Note: 1: 1706 2: -2147483647 3: SqlSupport.msi
MSI (s) (98:E4) [21:01:41:296]: SOURCEMGMT: Processing net source list.
MSI (s) (98:E4) [21:01:41:296]: Note: 1: 1706 2: -2147483647 3: SqlSupport.msi
MSI (s) (98:E4) [21:01:41:296]: SOURCEMGMT: Processing media source list.
MSI (s) (98:E4) [21:01:41:312]: Note: 1: 2203 2: 3: -2147287037
MSI (s) (98:E4) [21:01:41:312]: SOURCEMGMT: Source is invalid due to missing/inaccessible package.
MSI (s) (98:E4) [21:01:41:312]: Note: 1: 1706 2: -2147483647 3: SqlSupport.msi
MSI (s) (98:E4) [21:01:41:312]: SOURCEMGMT: Processing URL source list.
MSI (s) (98:E4) [21:01:41:312]: Note: 1: 1402 2: UNKNOWN\URL 3: 2
MSI (s) (98:E4) [21:01:41:312]: Note: 1: 1706 2: -2147483647 3: SqlSupport.msi
MSI (s) (98:E4) [21:01:41:312]: Note: 1: 1706 2: 3: SqlSupport.msi
MSI (s) (98:E4) [21:01:41:312]: SOURCEMGMT: Failed to resolve source
MSI (s) (98:E4) [21:01:41:312]: MainEngineThread is returning 1612
MSI (c) (2C:64) [21:01:41:312]: Decrementing counter to disable shutdown. If counter >= 0, shutdown will be denied. Counter after decrement: -1
MSI (c) (2C:64) [21:01:41:312]: MainEngineThread is returning 1612
=== Verbose logging stopped: 1/25/2007 21:01:41 ===

hi,

jklegseth wrote:

I have done all I can to resolve this on my own and would really appreciate any help anyone can give me. I have run uninstall utilities, followed a few MSDN reinstall methods, but all roads lead back to this vicious cycle:

The install hangs trying to install the prereq Microsoft SQL Server 2005 Setup Support Files with Error 1612. So I try to uninstall the Support files using Add/Remove..but the Windows Installer looks for "Microsoft SQL Server Native Client" disk, which of course I don't have because I install from downloads from Microsoft.

try manually installing SQL Native Client before the SQLExpress installation by running the relative package (half the page down)

regards

|||

Hi Andrea,

I tried what you suggested. Here is what happens.

- I get a warning that "A lower version of this product has been detected on your stystem. Would you like to upgrade your existing installation?"

- I click Yes

- Install seems to go fine -- it shows me what will be installed, etc., until I get a window saying, "Insert the 'Microsoft SQL Native Client' disk and click OK.

|||

Update: Using Windows Install Cleanup I was able to get past the Native error. I think there was a registry entry for Native install that was no longer valid. I got through the SQL install only to have a new problem. Now, during the installation System Configuration Check I pass 14 of 15 tests. I get a warning for Com Plus Catalog Requirement.

The warning message is: "Com Plus Catalog Requirement (Warning), Messages: If SQL Server Setup fails, Setup will roll back....For more information, see How to: Work Around Com+ Check Failure in SQL Server Setup."

I followed the steps in that KB article but when I add Component Services in the Console and click on Com+ Applications, I get an error: "ERror Code 8004E00F - COM+ was unable to talk to the Microsoft Distributed Transaction Coordinator.

So I looked that up and found various articles but none that seemed to apply directly to my problem.

If I continue the SQL Server setup and ignore the warning, I get a successful install of Setup Support Files, VSS WRiter, Backwards Compatability, but get failed warnings on all the of the SQL Express 2005 components. I'm once again stumped. Any ideas?

Thanks for your help.

|||

Update #2

I was to get past the above issue by following the steps at http://www.pcreview.co.uk/forums/thread-1596796.php. MSXML6 then failed during SQL Server install, so I removed it and reinstalled it. I am very close now. The error I now get is: "An instance with the same name is already installed on this computer. To proceed with SQL Server Setup, provide a unique instance name" I have followed the steps at http://blogs.msdn.com/astebner/archive/2005/12/08/501885.aspx but this has not resolved the. I can't believe how much time I've spent on this, but maybe this error is one you have encountered? I will keep searching and posting here so others with this issue can find help. If you have any ideas I would appreciate it.

error 1603 installing microsoft sql native client

I am sql server 2005 installed, and I do not think I have sql server
express. I tried to install express but I keep getting.
Error 1603 installing Microsoft SQL Native Client.
This worked before when reinstalling SQL Server 2005 but uninstalling it,
but will this hurt SQL server 2005 if I do it again for SQL Express?Hi
You will need to remove all references to the SQL Server 2005 before you
start the instalation. Did you have any prior to RTM vesrions on your
computer?
"Microsoft News Group" <mflynn@.cvmediaonline.com> wrote in message
news:%23Ip$rjMlGHA.3512@.TK2MSFTNGP03.phx.gbl...
>I am sql server 2005 installed, and I do not think I have sql server
>express. I tried to install express but I keep getting.
> Error 1603 installing Microsoft SQL Native Client.
> This worked before when reinstalling SQL Server 2005 but uninstalling it,
> but will this hurt SQL server 2005 if I do it again for SQL Express?
>|||When you mean references, do you mean all of SQL Server 2005? I would like
both on the computer, is that not possible. What is RTM versions? If I
uninstall Native Client from Add/Remove Programs, and install Express, will
that mess up SQL server 2005 in anyway, because I have no idea what the
native client is.
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:evuRYJPlGHA.1340@.TK2MSFTNGP02.phx.gbl...
> Hi
> You will need to remove all references to the SQL Server 2005 before you
> start the instalation. Did you have any prior to RTM vesrions on your
> computer?
>
>
>
> "Microsoft News Group" <mflynn@.cvmediaonline.com> wrote in message
> news:%23Ip$rjMlGHA.3512@.TK2MSFTNGP03.phx.gbl...
>>I am sql server 2005 installed, and I do not think I have sql server
>>express. I tried to install express but I keep getting.
>> Error 1603 installing Microsoft SQL Native Client.
>> This worked before when reinstalling SQL Server 2005 but uninstalling it,
>> but will this hurt SQL server 2005 if I do it again for SQL Express?
>

ERROR 1141 on mySQL creating a User on NT 4.0

Hi,

I just installed mySQL on MS NT 4.0 workstation and applied Service Pack
6a. When trying to add a new user using the Control Center I get an
info message that say that user was added but this is followed by an
error message that says:

There is no such grant defined for user 'username' on host 'hostname'

Does anyone know what is going on here?

Please respond in email.

Thanks,
Paul"Paul K. McKneely" <pkmckneely@.ev1.net> wrote in message
news:41499067.C056EB65@.ev1.net...
> Hi,
> I just installed mySQL on MS NT 4.0 workstation and applied Service Pack
> 6a. When trying to add a new user using the Control Center I get an
> info message that say that user was added but this is followed by an
> error message that says:
> There is no such grant defined for user 'username' on host 'hostname'
> Does anyone know what is going on here?
> Please respond in email.
> Thanks,
> Paul

This is an MSSQL (Microsoft SQL Server) newsgroup, so you will probably get
a better response in a MySQL forum.

Simon

Error 1053. The service did not respond to the start or control request in a timely fashio

I have a setup with SQL 2005 installed on x64 win2003.
After i register a 32 bit NT service, it fails to start.
Always get error "Error 1053. The service did not respond to the start
or control request in a timely fashion"
Is it related to "http://support.microsoft.com/kb/886695" ?
But this KB do not mention x64.
Anyone has any idea why the service control Manager returns error ?
trying using configuration mgr to reset the startup account. this should
ensure proper permissions are given to the acct/new sql local group.
-oj
<wn123456@.gmail.com> wrote in message
news:1172067716.276863.253090@.p10g2000cwp.googlegr oups.com...
>I have a setup with SQL 2005 installed on x64 win2003.
> After i register a 32 bit NT service, it fails to start.
> Always get error "Error 1053. The service did not respond to the start
> or control request in a timely fashion"
> Is it related to "http://support.microsoft.com/kb/886695" ?
> But this KB do not mention x64.
> Anyone has any idea why the service control Manager returns error ?
>
|||On Feb 22, 1:31 am, "oj" <nospam_oj...@.home.com> wrote:
> trying using configuration mgr to reset the startup account. this should
> ensure proper permissions are given to the acct/new sql local group.
> --
> -oj
> <wn123...@.gmail.com> wrote in message
> news:1172067716.276863.253090@.p10g2000cwp.googlegr oups.com...
>
>
>
> - Show quoted text -
Hi Oj,
Here my 32bit NT service fails to start. (SQL is up and running.)
This is observed only on the system with SQL 2005 - x64.
Is there some way to know what all steps "service control Manager"
perform before invoking the service.
Thanks,
wn
|||You can use ProcessMon
(http://www.microsoft.com/technet/sysinternals/utilities/processmonitor.mspx)
to step through the process.
-oj
<wn123456@.gmail.com> wrote in message
news:1172117914.387013.248870@.k78g2000cwa.googlegr oups.com...
> On Feb 22, 1:31 am, "oj" <nospam_oj...@.home.com> wrote:
> Hi Oj,
> Here my 32bit NT service fails to start. (SQL is up and running.)
> This is observed only on the system with SQL 2005 - x64.
> Is there some way to know what all steps "service control Manager"
> perform before invoking the service.
> Thanks,
> wn
>

Error 1053. The service did not respond to the start or control request in a timely fashio

I have a setup with SQL 2005 installed on x64 win2003.
After i register a 32 bit NT service, it fails to start.
Always get error "Error 1053. The service did not respond to the start
or control request in a timely fashion"
Is it related to "http://support.microsoft.com/kb/886695" ?
But this KB do not mention x64.
Anyone has any idea why the service control Manager returns error ?trying using configuration mgr to reset the startup account. this should
ensure proper permissions are given to the acct/new sql local group.
--
-oj
<wn123456@.gmail.com> wrote in message
news:1172067716.276863.253090@.p10g2000cwp.googlegroups.com...
>I have a setup with SQL 2005 installed on x64 win2003.
> After i register a 32 bit NT service, it fails to start.
> Always get error "Error 1053. The service did not respond to the start
> or control request in a timely fashion"
> Is it related to "http://support.microsoft.com/kb/886695" ?
> But this KB do not mention x64.
> Anyone has any idea why the service control Manager returns error ?
>|||On Feb 22, 1:31 am, "oj" <nospam_oj...@.home.com> wrote:
> trying using configuration mgr to reset the startup account. this should
> ensure proper permissions are given to the acct/new sql local group.
> --
> -oj
> <wn123...@.gmail.com> wrote in message
> news:1172067716.276863.253090@.p10g2000cwp.googlegroups.com...
>
> >I have a setup with SQL 2005 installed on x64 win2003.
> > After i register a 32 bit NT service, it fails to start.
> > Always get error "Error 1053. The service did not respond to the start
> > or control request in a timely fashion"
> > Is it related to "http://support.microsoft.com/kb/886695" ?
> > But this KB do not mention x64.
> > Anyone has any idea why the service control Manager returns error ... Hide quoted text -
> - Show quoted text -
Hi Oj,
Here my 32bit NT service fails to start. (SQL is up and running.)
This is observed only on the system with SQL 2005 - x64.
Is there some way to know what all steps "service control Manager"
perform before invoking the service.
Thanks,
wn|||You can use ProcessMon
(http://www.microsoft.com/technet/sysinternals/utilities/processmonitor.mspx)
to step through the process.
--
-oj
<wn123456@.gmail.com> wrote in message
news:1172117914.387013.248870@.k78g2000cwa.googlegroups.com...
> On Feb 22, 1:31 am, "oj" <nospam_oj...@.home.com> wrote:
>> trying using configuration mgr to reset the startup account. this should
>> ensure proper permissions are given to the acct/new sql local group.
>> --
>> -oj
>> <wn123...@.gmail.com> wrote in message
>> news:1172067716.276863.253090@.p10g2000cwp.googlegroups.com...
>>
>> >I have a setup with SQL 2005 installed on x64 win2003.
>> > After i register a 32 bit NT service, it fails to start.
>> > Always get error "Error 1053. The service did not respond to the start
>> > or control request in a timely fashion"
>> > Is it related to "http://support.microsoft.com/kb/886695" ?
>> > But this KB do not mention x64.
>> > Anyone has any idea why the service control Manager returns error ...
>> > Hide quoted text -
>> - Show quoted text -
> Hi Oj,
> Here my 32bit NT service fails to start. (SQL is up and running.)
> This is observed only on the system with SQL 2005 - x64.
> Is there some way to know what all steps "service control Manager"
> perform before invoking the service.
> Thanks,
> wn
>

Error 10061, SQL Server 2005 DEV actively refuses connection

I just installed a fresh SQL Server 2005 MSDN and tried to use the
management console, but all attempts to logon fail.
Message says 'failure may be caused by the fact that under the default
settings SQL Server does not allow remote connections.'
How can I change these settings or otherwise get a connection?
Thanks.First is to open up the Surface Area Configuration tool, select to
view Services and Connections. Under Database Engine, go to Remote
Connections. Change it to allow remote connections using whichever
protocols you plan on using from remote clients.
-Sue
On Tue, 17 Apr 2007 12:50:23 GMT, algernon bonzo <bonzo@.manchu.net>
wrote:

>I just installed a fresh SQL Server 2005 MSDN and tried to use the
>management console, but all attempts to logon fail.
>Message says 'failure may be caused by the fact that under the default
>settings SQL Server does not allow remote connections.'
>How can I change these settings or otherwise get a connection?
>Thanks.|||Worked. Thank you. New to 2005.
On Tue, 17 Apr 2007 11:45:22 -0600, Sue Hoegemeier
<Sue_H@.nomail.please> wrote:
[vbcol=seagreen]
>First is to open up the Surface Area Configuration tool, select to
>view Services and Connections. Under Database Engine, go to Remote
>Connections. Change it to allow remote connections using whichever
>protocols you plan on using from remote clients.
>-Sue
>On Tue, 17 Apr 2007 12:50:23 GMT, algernon bonzo <bonzo@.manchu.net>
>wrote:
>

error [could not find st.proc. "user _get total users"]

I installed a cd program and the sql database 2000 included in the cd.
However, when launching the program I get a message "could not find stored
procedure user-get total users'. If I continue I get a second later on "coul
d
not find stored procedure 'user -name in use '. The provider has no idea .
System is a P4 XP home sp2
I am not a specialist so before going to deep dive in the systems, is there
any thing "simple" than can be done ?From what CD do you install, is it a vendor specific Database (MSDE). What
"Program" are you starting when you get that error. Seems to me that this
might be a vendor specific problem, if you got an individual coded app.
More Information would be great.
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
--
"pink bear" <pink bear @.discussions.microsoft.com> schrieb im Newsbeitrag
news:FC323DB9-58A0-4BCF-BA75-8A6792D79CE3@.microsoft.com...
>I installed a cd program and the sql database 2000 included in the cd.
> However, when launching the program I get a message "could not find
> stored
> procedure user-get total users'. If I continue I get a second later on
> "could
> not find stored procedure 'user -name in use '. The provider has no idea .
> System is a P4 XP home sp2
> I am not a specialist so before going to deep dive in the systems, is
> there
> any thing "simple" than can be done ?|||Thanks Jens, It is a multimedia software , when installing it also proposes
to install SQL.The error starts after launching the program ( ican see part
of it) , it seems that it sends a login not registered in SQL, there must be
somewhere a table to update .
I have reintsalled everything including the sql, but the problem is still
there.
the strange thing is that in the very first install worked fine. I had to
reinstall x p and to reinstall all the programs, all went fine except for
this one.
"Jens Sü?meyer" wrote:

> From what CD do you install, is it a vendor specific Database (MSDE). What
> "Program" are you starting when you get that error. Seems to me that this
> might be a vendor specific problem, if you got an individual coded app.
> More Information would be great.
> HTH, Jens Suessmeyer.
> --
> http://www.sqlserver2005.de
> --
> "pink bear" <pink bear @.discussions.microsoft.com> schrieb im Newsbeitrag
> news:FC323DB9-58A0-4BCF-BA75-8A6792D79CE3@.microsoft.com...
>
>

error [could not find st.proc. "user _get total users"]

I installed a cd program and the sql database 2000 included in the cd.
However, when launching the program I get a message "could not find stored
procedure user-get total users'. If I continue I get a second later on "could
not find stored procedure 'user -name in use '. The provider has no idea .
System is a P4 XP home sp2
I am not a specialist so before going to deep dive in the systems, is there
any thing "simple" than can be done ?From what CD do you install, is it a vendor specific Database (MSDE). What
"Program" are you starting when you get that error. Seems to me that this
might be a vendor specific problem, if you got an individual coded app.
More Information would be great.
HTH, Jens Suessmeyer.
--
http://www.sqlserver2005.de
--
"pink bear" <pink bear @.discussions.microsoft.com> schrieb im Newsbeitrag
news:FC323DB9-58A0-4BCF-BA75-8A6792D79CE3@.microsoft.com...
>I installed a cd program and the sql database 2000 included in the cd.
> However, when launching the program I get a message "could not find
> stored
> procedure user-get total users'. If I continue I get a second later on
> "could
> not find stored procedure 'user -name in use '. The provider has no idea .
> System is a P4 XP home sp2
> I am not a specialist so before going to deep dive in the systems, is
> there
> any thing "simple" than can be done ?|||Thanks Jens, It is a multimedia software , when installing it also proposes
to install SQL.The error starts after launching the program ( ican see part
of it) , it seems that it sends a login not registered in SQL, there must be
somewhere a table to update .
I have reintsalled everything including the sql, but the problem is still
there.
the strange thing is that in the very first install worked fine. I had to
reinstall x p and to reinstall all the programs, all went fine except for
this one.
"Jens Sü�meyer" wrote:
> From what CD do you install, is it a vendor specific Database (MSDE). What
> "Program" are you starting when you get that error. Seems to me that this
> might be a vendor specific problem, if you got an individual coded app.
> More Information would be great.
> HTH, Jens Suessmeyer.
> --
> http://www.sqlserver2005.de
> --
> "pink bear" <pink bear @.discussions.microsoft.com> schrieb im Newsbeitrag
> news:FC323DB9-58A0-4BCF-BA75-8A6792D79CE3@.microsoft.com...
> >I installed a cd program and the sql database 2000 included in the cd.
> > However, when launching the program I get a message "could not find
> > stored
> > procedure user-get total users'. If I continue I get a second later on
> > "could
> > not find stored procedure 'user -name in use '. The provider has no idea .
> > System is a P4 XP home sp2
> > I am not a specialist so before going to deep dive in the systems, is
> > there
> > any thing "simple" than can be done ?
>
>

error [could not find st.proc. "user _get total users"]

I installed a cd program and the sql database 2000 included in the cd.
However, when launching the program I get a message "could not find stored
procedure user-get total users'. If I continue I get a second later on "could
not find stored procedure 'user -name in use '. The provider has no idea .
System is a P4 XP home sp2
I am not a specialist so before going to deep dive in the systems, is there
any thing "simple" than can be done ?
From what CD do you install, is it a vendor specific Database (MSDE). What
"Program" are you starting when you get that error. Seems to me that this
might be a vendor specific problem, if you got an individual coded app.
More Information would be great.
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
"pink bear" <pink bear @.discussions.microsoft.com> schrieb im Newsbeitrag
news:FC323DB9-58A0-4BCF-BA75-8A6792D79CE3@.microsoft.com...
>I installed a cd program and the sql database 2000 included in the cd.
> However, when launching the program I get a message "could not find
> stored
> procedure user-get total users'. If I continue I get a second later on
> "could
> not find stored procedure 'user -name in use '. The provider has no idea .
> System is a P4 XP home sp2
> I am not a specialist so before going to deep dive in the systems, is
> there
> any thing "simple" than can be done ?
|||Thanks Jens, It is a multimedia software , when installing it also proposes
to install SQL.The error starts after launching the program ( ican see part
of it) , it seems that it sends a login not registered in SQL, there must be
somewhere a table to update .
I have reintsalled everything including the sql, but the problem is still
there.
the strange thing is that in the very first install worked fine. I had to
reinstall x p and to reinstall all the programs, all went fine except for
this one.
"Jens Sü?meyer" wrote:

> From what CD do you install, is it a vendor specific Database (MSDE). What
> "Program" are you starting when you get that error. Seems to me that this
> might be a vendor specific problem, if you got an individual coded app.
> More Information would be great.
> HTH, Jens Suessmeyer.
> --
> http://www.sqlserver2005.de
> --
> "pink bear" <pink bear @.discussions.microsoft.com> schrieb im Newsbeitrag
> news:FC323DB9-58A0-4BCF-BA75-8A6792D79CE3@.microsoft.com...
>
>

Error : insufficient system memory

Hi,
We ran our application on Windows 2000 with SQL 2000 SP3a, and had no
issues. As soon as we installed the Database on Windows 2003 we are getting
the error saying that there is insufficient system memory. We get this at
least twice every week. Once this error happens most of SQL statements give
similar error message.
Kindly provide some help on this.
Here is the error message
SQLState: 42000, ErrorCode:701
[Microsoft][ODBC SQL Server Driver][SQL Server]There is insufficient system
memory to run this query.
--
Thanks,
Mr GeekWithout seeing a stack dump file , it is hard to say exactly what is causing
the problem.
Are the queries that trigger this problem , dealing with UNION ALL or IN
with largae data sets?
Have you thought about upgarding to sp4?
--
Jack Vamvas
__________________________________________________________________
"LSolve" <L0L@.newsgroups.nospam> wrote in message
news:F4561270-E1BA-4B4C-9841-DA55FE250789@.microsoft.com...
> Hi,
> We ran our application on Windows 2000 with SQL 2000 SP3a, and had no
> issues. As soon as we installed the Database on Windows 2003 we are
getting
> the error saying that there is insufficient system memory. We get this at
> least twice every week. Once this error happens most of SQL statements
give
> similar error message.
> Kindly provide some help on this.
> Here is the error message
> SQLState: 42000, ErrorCode:701
> [Microsoft][ODBC SQL Server Driver][SQL Server]There is insufficient
system
> memory to run this query.
> --
> Thanks,
> Mr Geek|||Hello,
Please refer to the following article which describes how to troubleshoot
the slow performance of many concurrent ad-hoc queries:
243588 HOW TO: Troubleshoot the Performance of Ad-Hoc Queries
http://support.microsoft.com/?id=243588
I hope the information is helpful.
Sophie Guo
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
=====================================================When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||Hi Lsolve,
If u want to check that ur sql server need more merory then check this
artical .
http://www.computerperformance.co.uk/HealthCheck/Memory_Health.htm
from
Doller

Error : insufficient system memory

Hi,
We ran our application on Windows 2000 with SQL 2000 SP3a, and had no
issues. As soon as we installed the Database on Windows 2003 we are getting
the error saying that there is insufficient system memory. We get this at
least twice every week. Once this error happens most of SQL statements give
similar error message when run from query analyzer.
Kindly provide some help on this.
Here is the error message
SQLState: 42000, ErrorCode:701
[Microsoft][ODBC SQL Server Driver][SQL Server]There is insufficient system
memory to run this query.You might want to give MS PSS a call:
http://support.microsoft.com/default.aspx?scid=fh;EN-US;sql SQL Support
http://www.mssqlserver.com/faq/general-pss.asp MS PSS
--
Andrew J. Kelly SQL MVP
"LSolve" <LSolve@.discussions.microsoft.com> wrote in message
news:42FBA2DD-8B32-48E2-9CFD-805E88A6DCDA@.microsoft.com...
> Hi,
> We ran our application on Windows 2000 with SQL 2000 SP3a, and had no
> issues. As soon as we installed the Database on Windows 2003 we are
> getting
> the error saying that there is insufficient system memory. We get this at
> least twice every week. Once this error happens most of SQL statements
> give
> similar error message when run from query analyzer.
> Kindly provide some help on this.
> Here is the error message
> SQLState: 42000, ErrorCode:701
> [Microsoft][ODBC SQL Server Driver][SQL Server]There is insufficient
> system
> memory to run this query.
>