We have a SQL installation that was setup with Windows Authentication.
The software we will run requires SQL Authentication (Mixed Mode).
When I right click on properties, go to the security tab, click the SQL
Authentication, click on OK and it exits. However, when I go back in
and look at the security tab, it is still set on Windows
Authentication. I tried restarting the SQL services and I get the same
thing.
Ideas?
I have resolved this issue by logging in as the domain admin. I had
previously tried using a local admin account.
jd
JohnDoe wrote:
> We have a SQL installation that was setup with Windows Authentication.
> The software we will run requires SQL Authentication (Mixed Mode).
> When I right click on properties, go to the security tab, click the SQL
> Authentication, click on OK and it exits. However, when I go back in
> and look at the security tab, it is still set on Windows
> Authentication. I tried restarting the SQL services and I get the same
> thing.
> Ideas?
Showing posts with label installation. Show all posts
Showing posts with label installation. Show all posts
Thursday, March 29, 2012
Can't Switch to SQL Authentication (Mixed Mode)
We have a SQL installation that was setup with Windows Authentication.
The software we will run requires SQL Authentication (Mixed Mode).
When I right click on properties, go to the security tab, click the SQL
Authentication, click on OK and it exits. However, when I go back in
and look at the security tab, it is still set on Windows
Authentication. I tried restarting the SQL services and I get the same
thing.
Ideas?I have resolved this issue by logging in as the domain admin. I had
previously tried using a local admin account.
jd
JohnDoe wrote:
> We have a SQL installation that was setup with Windows Authentication.
> The software we will run requires SQL Authentication (Mixed Mode).
> When I right click on properties, go to the security tab, click the SQL
> Authentication, click on OK and it exits. However, when I go back in
> and look at the security tab, it is still set on Windows
> Authentication. I tried restarting the SQL services and I get the same
> thing.
> Ideas?
The software we will run requires SQL Authentication (Mixed Mode).
When I right click on properties, go to the security tab, click the SQL
Authentication, click on OK and it exits. However, when I go back in
and look at the security tab, it is still set on Windows
Authentication. I tried restarting the SQL services and I get the same
thing.
Ideas?I have resolved this issue by logging in as the domain admin. I had
previously tried using a local admin account.
jd
JohnDoe wrote:
> We have a SQL installation that was setup with Windows Authentication.
> The software we will run requires SQL Authentication (Mixed Mode).
> When I right click on properties, go to the security tab, click the SQL
> Authentication, click on OK and it exits. However, when I go back in
> and look at the security tab, it is still set on Windows
> Authentication. I tried restarting the SQL services and I get the same
> thing.
> Ideas?
Can't Switch to SQL Authentication (Mixed Mode)
We have a SQL installation that was setup with Windows Authentication.
The software we will run requires SQL Authentication (Mixed Mode).
When I right click on properties, go to the security tab, click the SQL
Authentication, click on OK and it exits. However, when I go back in
and look at the security tab, it is still set on Windows
Authentication. I tried restarting the SQL services and I get the same
thing.
Ideas?I have resolved this issue by logging in as the domain admin. I had
previously tried using a local admin account.
jd
JohnDoe wrote:
> We have a SQL installation that was setup with Windows Authentication.
> The software we will run requires SQL Authentication (Mixed Mode).
> When I right click on properties, go to the security tab, click the SQL
> Authentication, click on OK and it exits. However, when I go back in
> and look at the security tab, it is still set on Windows
> Authentication. I tried restarting the SQL services and I get the same
> thing.
> Ideas?
The software we will run requires SQL Authentication (Mixed Mode).
When I right click on properties, go to the security tab, click the SQL
Authentication, click on OK and it exits. However, when I go back in
and look at the security tab, it is still set on Windows
Authentication. I tried restarting the SQL services and I get the same
thing.
Ideas?I have resolved this issue by logging in as the domain admin. I had
previously tried using a local admin account.
jd
JohnDoe wrote:
> We have a SQL installation that was setup with Windows Authentication.
> The software we will run requires SQL Authentication (Mixed Mode).
> When I right click on properties, go to the security tab, click the SQL
> Authentication, click on OK and it exits. However, when I go back in
> and look at the security tab, it is still set on Windows
> Authentication. I tried restarting the SQL services and I get the same
> thing.
> Ideas?
Wednesday, March 7, 2012
Can't query attached database
Hello.
I received a detached database/log from my client. I attached the
database to my SQLServer 2000 SP3 installation just fine. In the
enterprise manager I can query any table I want.
However, when I attempt to query a table via the query analyzer, it
always fails, even though I am logged in as the "sa".
Below is my query and the result. I am not having this trouble with any
other database on the system.
select * from employee
Below is the error message:
Server: Msg 208, Level 16, State 1, Line 1
Invalid object name 'employee'.
Any help would be appreciated.
Thanks,
Christian
pariahware@.pariahware.com
Pariahware, Inc. Custom Software and Shareware
http://www.pariahware.com
--
God loved you so much that He gave His only son Jesus.
What have you done with God's gift?Is there really a table called employee? Are you in the right database? Who is the owner of that table?
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Christian Miller" <pariahware@.pariahware.com> wrote in message
news:pariahware-434093.15550916062004@.news2-ge0.southeast.rr.com...
> Hello.
> I received a detached database/log from my client. I attached the
> database to my SQLServer 2000 SP3 installation just fine. In the
> enterprise manager I can query any table I want.
> However, when I attempt to query a table via the query analyzer, it
> always fails, even though I am logged in as the "sa".
> Below is my query and the result. I am not having this trouble with any
> other database on the system.
> select * from employee
> Below is the error message:
> Server: Msg 208, Level 16, State 1, Line 1
> Invalid object name 'employee'.
> Any help would be appreciated.
> Thanks,
> Christian
> pariahware@.pariahware.com
> Pariahware, Inc. Custom Software and Shareware
> http://www.pariahware.com
> --
> God loved you so much that He gave His only son Jesus.
> What have you done with God's gift?|||In article <uwTZNx9UEHA.1048@.TK2MSFTNGP09.phx.gbl>,
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com>
wrote:
> Is there really a table called employee?
Yes, I can view it in the enterprise manager.
> Are you in the right database?
Yes, I've even used the "use" command to make sure, on occassion.
> Who is the owner of that table?
The owner of the table is "dbo".
When I look under the db's users, "dbo" is a name entry, "sa" is the
login name and access is "permit".|||Try:
SELECT * FROM dbname.dbo.employee. Also, the server might be case-sensitive, make sure you use proper case.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Christian Miller" <pariahware@.pariahware.com> wrote in message
news:pariahware-21E05C.16194316062004@.news2-ge0.southeast.rr.com...
> In article <uwTZNx9UEHA.1048@.TK2MSFTNGP09.phx.gbl>,
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com>
> wrote:
> > Is there really a table called employee?
> Yes, I can view it in the enterprise manager.
> > Are you in the right database?
> Yes, I've even used the "use" command to make sure, on occassion.
> > Who is the owner of that table?
> The owner of the table is "dbo".
> When I look under the db's users, "dbo" is a name entry, "sa" is the
> login name and access is "permit".|||In article
<pariahware-21E05C.16194316062004@.news2-ge0.southeast.rr.com>,
Christian Miller <pariahware@.pariahware.com> wrote:
> In article <uwTZNx9UEHA.1048@.TK2MSFTNGP09.phx.gbl>,
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com>
> wrote:
> > Is there really a table called employee?
> Yes, I can view it in the enterprise manager.
> > Are you in the right database?
> Yes, I've even used the "use" command to make sure, on occassion.
> > Who is the owner of that table?
> The owner of the table is "dbo".
> When I look under the db's users, "dbo" is a name entry, "sa" is the
> login name and access is "permit".
OK, apparently there is not a database table called "employee", but
there is one called "EMPLOYEE". I don't ever remember table name case
being an issue when performing a querying before. I normally uppercase
key words and lowercase table names. Is this a setting in my SQL Server
that I accidentally set?
Thanks,
Christian
pariahware@.pariahware.com
Pariahware, Inc. Custom Software and Shareware
http://www.pariahware.com
--
God loved you so much that He gave His only son Jesus.
What have you done with God's gift?|||Case sensitivity for object names is based on the database collation (if my memory serves me).
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Christian Miller" <pariahware@.pariahware.com> wrote in message
news:pariahware-11C0F9.16271516062004@.news2-ge0.southeast.rr.com...
> In article
> <pariahware-21E05C.16194316062004@.news2-ge0.southeast.rr.com>,
> Christian Miller <pariahware@.pariahware.com> wrote:
> > In article <uwTZNx9UEHA.1048@.TK2MSFTNGP09.phx.gbl>,
> > "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com>
> > wrote:
> >
> > > Is there really a table called employee?
> > Yes, I can view it in the enterprise manager.
> >
> > > Are you in the right database?
> > Yes, I've even used the "use" command to make sure, on occassion.
> >
> > > Who is the owner of that table?
> > The owner of the table is "dbo".
> >
> > When I look under the db's users, "dbo" is a name entry, "sa" is the
> > login name and access is "permit".
> OK, apparently there is not a database table called "employee", but
> there is one called "EMPLOYEE". I don't ever remember table name case
> being an issue when performing a querying before. I normally uppercase
> key words and lowercase table names. Is this a setting in my SQL Server
> that I accidentally set?
>
> Thanks,
> Christian
> pariahware@.pariahware.com
> Pariahware, Inc. Custom Software and Shareware
> http://www.pariahware.com
> --
> God loved you so much that He gave His only son Jesus.
> What have you done with God's gift?|||In article <u2N$QN#UEHA.2920@.TK2MSFTNGP10.phx.gbl>,
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com>
wrote:
> Case sensitivity for object names is based on the database collation (if my
> memory serves me).
If that per database file or per server? How would I turn off database
collation if I wanted to? I really appreciate all the help on this.
Thanks,
Christian
pariahware@.pariahware.com
Pariahware, Inc. Custom Software and Shareware
http://www.pariahware.com
--
God loved you so much that He gave His only son Jesus.
What have you done with God's gift?|||Try sp_helpsort to determine the the sort order.
"Christian Miller" <pariahware@.pariahware.com> wrote in message
news:pariahware-434093.15550916062004@.news2-ge0.southeast.rr.com...
> Hello.
> I received a detached database/log from my client. I attached the
> database to my SQLServer 2000 SP3 installation just fine. In the
> enterprise manager I can query any table I want.
> However, when I attempt to query a table via the query analyzer, it
> always fails, even though I am logged in as the "sa".
> Below is my query and the result. I am not having this trouble with any
> other database on the system.
> select * from employee
> Below is the error message:
> Server: Msg 208, Level 16, State 1, Line 1
> Invalid object name 'employee'.
> Any help would be appreciated.
> Thanks,
> Christian
> pariahware@.pariahware.com
> Pariahware, Inc. Custom Software and Shareware
> http://www.pariahware.com
> --
> God loved you so much that He gave His only son Jesus.
> What have you done with God's gift?
I received a detached database/log from my client. I attached the
database to my SQLServer 2000 SP3 installation just fine. In the
enterprise manager I can query any table I want.
However, when I attempt to query a table via the query analyzer, it
always fails, even though I am logged in as the "sa".
Below is my query and the result. I am not having this trouble with any
other database on the system.
select * from employee
Below is the error message:
Server: Msg 208, Level 16, State 1, Line 1
Invalid object name 'employee'.
Any help would be appreciated.
Thanks,
Christian
pariahware@.pariahware.com
Pariahware, Inc. Custom Software and Shareware
http://www.pariahware.com
--
God loved you so much that He gave His only son Jesus.
What have you done with God's gift?Is there really a table called employee? Are you in the right database? Who is the owner of that table?
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Christian Miller" <pariahware@.pariahware.com> wrote in message
news:pariahware-434093.15550916062004@.news2-ge0.southeast.rr.com...
> Hello.
> I received a detached database/log from my client. I attached the
> database to my SQLServer 2000 SP3 installation just fine. In the
> enterprise manager I can query any table I want.
> However, when I attempt to query a table via the query analyzer, it
> always fails, even though I am logged in as the "sa".
> Below is my query and the result. I am not having this trouble with any
> other database on the system.
> select * from employee
> Below is the error message:
> Server: Msg 208, Level 16, State 1, Line 1
> Invalid object name 'employee'.
> Any help would be appreciated.
> Thanks,
> Christian
> pariahware@.pariahware.com
> Pariahware, Inc. Custom Software and Shareware
> http://www.pariahware.com
> --
> God loved you so much that He gave His only son Jesus.
> What have you done with God's gift?|||In article <uwTZNx9UEHA.1048@.TK2MSFTNGP09.phx.gbl>,
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com>
wrote:
> Is there really a table called employee?
Yes, I can view it in the enterprise manager.
> Are you in the right database?
Yes, I've even used the "use" command to make sure, on occassion.
> Who is the owner of that table?
The owner of the table is "dbo".
When I look under the db's users, "dbo" is a name entry, "sa" is the
login name and access is "permit".|||Try:
SELECT * FROM dbname.dbo.employee. Also, the server might be case-sensitive, make sure you use proper case.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Christian Miller" <pariahware@.pariahware.com> wrote in message
news:pariahware-21E05C.16194316062004@.news2-ge0.southeast.rr.com...
> In article <uwTZNx9UEHA.1048@.TK2MSFTNGP09.phx.gbl>,
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com>
> wrote:
> > Is there really a table called employee?
> Yes, I can view it in the enterprise manager.
> > Are you in the right database?
> Yes, I've even used the "use" command to make sure, on occassion.
> > Who is the owner of that table?
> The owner of the table is "dbo".
> When I look under the db's users, "dbo" is a name entry, "sa" is the
> login name and access is "permit".|||In article
<pariahware-21E05C.16194316062004@.news2-ge0.southeast.rr.com>,
Christian Miller <pariahware@.pariahware.com> wrote:
> In article <uwTZNx9UEHA.1048@.TK2MSFTNGP09.phx.gbl>,
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com>
> wrote:
> > Is there really a table called employee?
> Yes, I can view it in the enterprise manager.
> > Are you in the right database?
> Yes, I've even used the "use" command to make sure, on occassion.
> > Who is the owner of that table?
> The owner of the table is "dbo".
> When I look under the db's users, "dbo" is a name entry, "sa" is the
> login name and access is "permit".
OK, apparently there is not a database table called "employee", but
there is one called "EMPLOYEE". I don't ever remember table name case
being an issue when performing a querying before. I normally uppercase
key words and lowercase table names. Is this a setting in my SQL Server
that I accidentally set?
Thanks,
Christian
pariahware@.pariahware.com
Pariahware, Inc. Custom Software and Shareware
http://www.pariahware.com
--
God loved you so much that He gave His only son Jesus.
What have you done with God's gift?|||Case sensitivity for object names is based on the database collation (if my memory serves me).
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Christian Miller" <pariahware@.pariahware.com> wrote in message
news:pariahware-11C0F9.16271516062004@.news2-ge0.southeast.rr.com...
> In article
> <pariahware-21E05C.16194316062004@.news2-ge0.southeast.rr.com>,
> Christian Miller <pariahware@.pariahware.com> wrote:
> > In article <uwTZNx9UEHA.1048@.TK2MSFTNGP09.phx.gbl>,
> > "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com>
> > wrote:
> >
> > > Is there really a table called employee?
> > Yes, I can view it in the enterprise manager.
> >
> > > Are you in the right database?
> > Yes, I've even used the "use" command to make sure, on occassion.
> >
> > > Who is the owner of that table?
> > The owner of the table is "dbo".
> >
> > When I look under the db's users, "dbo" is a name entry, "sa" is the
> > login name and access is "permit".
> OK, apparently there is not a database table called "employee", but
> there is one called "EMPLOYEE". I don't ever remember table name case
> being an issue when performing a querying before. I normally uppercase
> key words and lowercase table names. Is this a setting in my SQL Server
> that I accidentally set?
>
> Thanks,
> Christian
> pariahware@.pariahware.com
> Pariahware, Inc. Custom Software and Shareware
> http://www.pariahware.com
> --
> God loved you so much that He gave His only son Jesus.
> What have you done with God's gift?|||In article <u2N$QN#UEHA.2920@.TK2MSFTNGP10.phx.gbl>,
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com>
wrote:
> Case sensitivity for object names is based on the database collation (if my
> memory serves me).
If that per database file or per server? How would I turn off database
collation if I wanted to? I really appreciate all the help on this.
Thanks,
Christian
pariahware@.pariahware.com
Pariahware, Inc. Custom Software and Shareware
http://www.pariahware.com
--
God loved you so much that He gave His only son Jesus.
What have you done with God's gift?|||Try sp_helpsort to determine the the sort order.
"Christian Miller" <pariahware@.pariahware.com> wrote in message
news:pariahware-434093.15550916062004@.news2-ge0.southeast.rr.com...
> Hello.
> I received a detached database/log from my client. I attached the
> database to my SQLServer 2000 SP3 installation just fine. In the
> enterprise manager I can query any table I want.
> However, when I attempt to query a table via the query analyzer, it
> always fails, even though I am logged in as the "sa".
> Below is my query and the result. I am not having this trouble with any
> other database on the system.
> select * from employee
> Below is the error message:
> Server: Msg 208, Level 16, State 1, Line 1
> Invalid object name 'employee'.
> Any help would be appreciated.
> Thanks,
> Christian
> pariahware@.pariahware.com
> Pariahware, Inc. Custom Software and Shareware
> http://www.pariahware.com
> --
> God loved you so much that He gave His only son Jesus.
> What have you done with God's gift?
Can't query attached database
Hello.
I received a detached database/log from my client. I attached the
database to my SQLServer 2000 SP3 installation just fine. In the
enterprise manager I can query any table I want.
However, when I attempt to query a table via the query analyzer, it
always fails, even though I am logged in as the "sa".
Below is my query and the result. I am not having this trouble with any
other database on the system.
select * from employee
Below is the error message:
Server: Msg 208, Level 16, State 1, Line 1
Invalid object name 'employee'.
Any help would be appreciated.
Thanks,
Christian
pariahware@.pariahware.com
Pariahware, Inc. Custom Software and Shareware
http://www.pariahware.com
God loved you so much that He gave His only son Jesus.
What have you done with God's gift?
Is there really a table called employee? Are you in the right database? Who is the owner of that table?
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Christian Miller" <pariahware@.pariahware.com> wrote in message
news:pariahware-434093.15550916062004@.news2-ge0.southeast.rr.com...
> Hello.
> I received a detached database/log from my client. I attached the
> database to my SQLServer 2000 SP3 installation just fine. In the
> enterprise manager I can query any table I want.
> However, when I attempt to query a table via the query analyzer, it
> always fails, even though I am logged in as the "sa".
> Below is my query and the result. I am not having this trouble with any
> other database on the system.
> select * from employee
> Below is the error message:
> Server: Msg 208, Level 16, State 1, Line 1
> Invalid object name 'employee'.
> Any help would be appreciated.
> Thanks,
> Christian
> pariahware@.pariahware.com
> Pariahware, Inc. Custom Software and Shareware
> http://www.pariahware.com
> --
> God loved you so much that He gave His only son Jesus.
> What have you done with God's gift?
|||In article <uwTZNx9UEHA.1048@.TK2MSFTNGP09.phx.gbl>,
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com>
wrote:
> Is there really a table called employee?
Yes, I can view it in the enterprise manager.
> Are you in the right database?
Yes, I've even used the "use" command to make sure, on occassion.
> Who is the owner of that table?
The owner of the table is "dbo".
When I look under the db's users, "dbo" is a name entry, "sa" is the
login name and access is "permit".
|||Try:
SELECT * FROM dbname.dbo.employee. Also, the server might be case-sensitive, make sure you use proper case.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Christian Miller" <pariahware@.pariahware.com> wrote in message
news:pariahware-21E05C.16194316062004@.news2-ge0.southeast.rr.com...
> In article <uwTZNx9UEHA.1048@.TK2MSFTNGP09.phx.gbl>,
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com>
> wrote:
> Yes, I can view it in the enterprise manager.
> Yes, I've even used the "use" command to make sure, on occassion.
> The owner of the table is "dbo".
> When I look under the db's users, "dbo" is a name entry, "sa" is the
> login name and access is "permit".
|||Try sp_helpsort to determine the the sort order.
"Christian Miller" <pariahware@.pariahware.com> wrote in message
news:pariahware-434093.15550916062004@.news2-ge0.southeast.rr.com...
> Hello.
> I received a detached database/log from my client. I attached the
> database to my SQLServer 2000 SP3 installation just fine. In the
> enterprise manager I can query any table I want.
> However, when I attempt to query a table via the query analyzer, it
> always fails, even though I am logged in as the "sa".
> Below is my query and the result. I am not having this trouble with any
> other database on the system.
> select * from employee
> Below is the error message:
> Server: Msg 208, Level 16, State 1, Line 1
> Invalid object name 'employee'.
> Any help would be appreciated.
> Thanks,
> Christian
> pariahware@.pariahware.com
> Pariahware, Inc. Custom Software and Shareware
> http://www.pariahware.com
> --
> God loved you so much that He gave His only son Jesus.
> What have you done with God's gift?
I received a detached database/log from my client. I attached the
database to my SQLServer 2000 SP3 installation just fine. In the
enterprise manager I can query any table I want.
However, when I attempt to query a table via the query analyzer, it
always fails, even though I am logged in as the "sa".
Below is my query and the result. I am not having this trouble with any
other database on the system.
select * from employee
Below is the error message:
Server: Msg 208, Level 16, State 1, Line 1
Invalid object name 'employee'.
Any help would be appreciated.
Thanks,
Christian
pariahware@.pariahware.com
Pariahware, Inc. Custom Software and Shareware
http://www.pariahware.com
God loved you so much that He gave His only son Jesus.
What have you done with God's gift?
Is there really a table called employee? Are you in the right database? Who is the owner of that table?
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Christian Miller" <pariahware@.pariahware.com> wrote in message
news:pariahware-434093.15550916062004@.news2-ge0.southeast.rr.com...
> Hello.
> I received a detached database/log from my client. I attached the
> database to my SQLServer 2000 SP3 installation just fine. In the
> enterprise manager I can query any table I want.
> However, when I attempt to query a table via the query analyzer, it
> always fails, even though I am logged in as the "sa".
> Below is my query and the result. I am not having this trouble with any
> other database on the system.
> select * from employee
> Below is the error message:
> Server: Msg 208, Level 16, State 1, Line 1
> Invalid object name 'employee'.
> Any help would be appreciated.
> Thanks,
> Christian
> pariahware@.pariahware.com
> Pariahware, Inc. Custom Software and Shareware
> http://www.pariahware.com
> --
> God loved you so much that He gave His only son Jesus.
> What have you done with God's gift?
|||In article <uwTZNx9UEHA.1048@.TK2MSFTNGP09.phx.gbl>,
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com>
wrote:
> Is there really a table called employee?
Yes, I can view it in the enterprise manager.
> Are you in the right database?
Yes, I've even used the "use" command to make sure, on occassion.
> Who is the owner of that table?
The owner of the table is "dbo".
When I look under the db's users, "dbo" is a name entry, "sa" is the
login name and access is "permit".
|||Try:
SELECT * FROM dbname.dbo.employee. Also, the server might be case-sensitive, make sure you use proper case.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Christian Miller" <pariahware@.pariahware.com> wrote in message
news:pariahware-21E05C.16194316062004@.news2-ge0.southeast.rr.com...
> In article <uwTZNx9UEHA.1048@.TK2MSFTNGP09.phx.gbl>,
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com>
> wrote:
> Yes, I can view it in the enterprise manager.
> Yes, I've even used the "use" command to make sure, on occassion.
> The owner of the table is "dbo".
> When I look under the db's users, "dbo" is a name entry, "sa" is the
> login name and access is "permit".
|||Try sp_helpsort to determine the the sort order.
"Christian Miller" <pariahware@.pariahware.com> wrote in message
news:pariahware-434093.15550916062004@.news2-ge0.southeast.rr.com...
> Hello.
> I received a detached database/log from my client. I attached the
> database to my SQLServer 2000 SP3 installation just fine. In the
> enterprise manager I can query any table I want.
> However, when I attempt to query a table via the query analyzer, it
> always fails, even though I am logged in as the "sa".
> Below is my query and the result. I am not having this trouble with any
> other database on the system.
> select * from employee
> Below is the error message:
> Server: Msg 208, Level 16, State 1, Line 1
> Invalid object name 'employee'.
> Any help would be appreciated.
> Thanks,
> Christian
> pariahware@.pariahware.com
> Pariahware, Inc. Custom Software and Shareware
> http://www.pariahware.com
> --
> God loved you so much that He gave His only son Jesus.
> What have you done with God's gift?
Can't query attached database
Hello.
I received a detached database/log from my client. I attached the
database to my SQLServer 2000 SP3 installation just fine. In the
enterprise manager I can query any table I want.
However, when I attempt to query a table via the query analyzer, it
always fails, even though I am logged in as the "sa".
Below is my query and the result. I am not having this trouble with any
other database on the system.
select * from employee
Below is the error message:
Server: Msg 208, Level 16, State 1, Line 1
Invalid object name 'employee'.
Any help would be appreciated.
Thanks,
Christian
pariahware@.pariahware.com
Pariahware, Inc. Custom Software and Shareware
http://www.pariahware.com
--
God loved you so much that He gave His only son Jesus.
What have you done with God's gift?Is there really a table called employee? Are you in the right database? Who
is the owner of that table?
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Christian Miller" <pariahware@.pariahware.com> wrote in message
news:pariahware-434093.15550916062004@.news2-ge0.southeast.rr.com...
> Hello.
> I received a detached database/log from my client. I attached the
> database to my SQLServer 2000 SP3 installation just fine. In the
> enterprise manager I can query any table I want.
> However, when I attempt to query a table via the query analyzer, it
> always fails, even though I am logged in as the "sa".
> Below is my query and the result. I am not having this trouble with any
> other database on the system.
> select * from employee
> Below is the error message:
> Server: Msg 208, Level 16, State 1, Line 1
> Invalid object name 'employee'.
> Any help would be appreciated.
> Thanks,
> Christian
> pariahware@.pariahware.com
> Pariahware, Inc. Custom Software and Shareware
> http://www.pariahware.com
> --
> God loved you so much that He gave His only son Jesus.
> What have you done with God's gift?|||In article <uwTZNx9UEHA.1048@.TK2MSFTNGP09.phx.gbl>,
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com>
wrote:
> Is there really a table called employee?
Yes, I can view it in the enterprise manager.
> Are you in the right database?
Yes, I've even used the "use" command to make sure, on occassion.
> Who is the owner of that table?
The owner of the table is "dbo".
When I look under the db's users, "dbo" is a name entry, "sa" is the
login name and access is "permit".|||Try:
SELECT * FROM dbname.dbo.employee. Also, the server might be case-sensitive,
make sure you use proper case.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Christian Miller" <pariahware@.pariahware.com> wrote in message
news:pariahware-21E05C.16194316062004@.news2-ge0.southeast.rr.com...
> In article <uwTZNx9UEHA.1048@.TK2MSFTNGP09.phx.gbl>,
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com>
> wrote:
>
> Yes, I can view it in the enterprise manager.
>
> Yes, I've even used the "use" command to make sure, on occassion.
>
> The owner of the table is "dbo".
> When I look under the db's users, "dbo" is a name entry, "sa" is the
> login name and access is "permit".|||Try sp_helpsort to determine the the sort order.
"Christian Miller" <pariahware@.pariahware.com> wrote in message
news:pariahware-434093.15550916062004@.news2-ge0.southeast.rr.com...
> Hello.
> I received a detached database/log from my client. I attached the
> database to my SQLServer 2000 SP3 installation just fine. In the
> enterprise manager I can query any table I want.
> However, when I attempt to query a table via the query analyzer, it
> always fails, even though I am logged in as the "sa".
> Below is my query and the result. I am not having this trouble with any
> other database on the system.
> select * from employee
> Below is the error message:
> Server: Msg 208, Level 16, State 1, Line 1
> Invalid object name 'employee'.
> Any help would be appreciated.
> Thanks,
> Christian
> pariahware@.pariahware.com
> Pariahware, Inc. Custom Software and Shareware
> http://www.pariahware.com
> --
> God loved you so much that He gave His only son Jesus.
> What have you done with God's gift?
I received a detached database/log from my client. I attached the
database to my SQLServer 2000 SP3 installation just fine. In the
enterprise manager I can query any table I want.
However, when I attempt to query a table via the query analyzer, it
always fails, even though I am logged in as the "sa".
Below is my query and the result. I am not having this trouble with any
other database on the system.
select * from employee
Below is the error message:
Server: Msg 208, Level 16, State 1, Line 1
Invalid object name 'employee'.
Any help would be appreciated.
Thanks,
Christian
pariahware@.pariahware.com
Pariahware, Inc. Custom Software and Shareware
http://www.pariahware.com
--
God loved you so much that He gave His only son Jesus.
What have you done with God's gift?Is there really a table called employee? Are you in the right database? Who
is the owner of that table?
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Christian Miller" <pariahware@.pariahware.com> wrote in message
news:pariahware-434093.15550916062004@.news2-ge0.southeast.rr.com...
> Hello.
> I received a detached database/log from my client. I attached the
> database to my SQLServer 2000 SP3 installation just fine. In the
> enterprise manager I can query any table I want.
> However, when I attempt to query a table via the query analyzer, it
> always fails, even though I am logged in as the "sa".
> Below is my query and the result. I am not having this trouble with any
> other database on the system.
> select * from employee
> Below is the error message:
> Server: Msg 208, Level 16, State 1, Line 1
> Invalid object name 'employee'.
> Any help would be appreciated.
> Thanks,
> Christian
> pariahware@.pariahware.com
> Pariahware, Inc. Custom Software and Shareware
> http://www.pariahware.com
> --
> God loved you so much that He gave His only son Jesus.
> What have you done with God's gift?|||In article <uwTZNx9UEHA.1048@.TK2MSFTNGP09.phx.gbl>,
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com>
wrote:
> Is there really a table called employee?
Yes, I can view it in the enterprise manager.
> Are you in the right database?
Yes, I've even used the "use" command to make sure, on occassion.
> Who is the owner of that table?
The owner of the table is "dbo".
When I look under the db's users, "dbo" is a name entry, "sa" is the
login name and access is "permit".|||Try:
SELECT * FROM dbname.dbo.employee. Also, the server might be case-sensitive,
make sure you use proper case.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Christian Miller" <pariahware@.pariahware.com> wrote in message
news:pariahware-21E05C.16194316062004@.news2-ge0.southeast.rr.com...
> In article <uwTZNx9UEHA.1048@.TK2MSFTNGP09.phx.gbl>,
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com>
> wrote:
>
> Yes, I can view it in the enterprise manager.
>
> Yes, I've even used the "use" command to make sure, on occassion.
>
> The owner of the table is "dbo".
> When I look under the db's users, "dbo" is a name entry, "sa" is the
> login name and access is "permit".|||Try sp_helpsort to determine the the sort order.
"Christian Miller" <pariahware@.pariahware.com> wrote in message
news:pariahware-434093.15550916062004@.news2-ge0.southeast.rr.com...
> Hello.
> I received a detached database/log from my client. I attached the
> database to my SQLServer 2000 SP3 installation just fine. In the
> enterprise manager I can query any table I want.
> However, when I attempt to query a table via the query analyzer, it
> always fails, even though I am logged in as the "sa".
> Below is my query and the result. I am not having this trouble with any
> other database on the system.
> select * from employee
> Below is the error message:
> Server: Msg 208, Level 16, State 1, Line 1
> Invalid object name 'employee'.
> Any help would be appreciated.
> Thanks,
> Christian
> pariahware@.pariahware.com
> Pariahware, Inc. Custom Software and Shareware
> http://www.pariahware.com
> --
> God loved you so much that He gave His only son Jesus.
> What have you done with God's gift?
Sunday, February 19, 2012
Cant load up Reporting Services
Hi there
Im a newbie to Reporting Services and am trying it out on SQL Server 2005
I went through the installation process for Reporting Services and installed
a sample database from the Microsoft Press Book on Reporting Services.
I tried to navigate to the following location :
http://localhost/Reports/Pages/Folder.aspx
but i get the following error message
The report server cannot open a connection to the report
server database. A connection to the database is required for all requests
and processing. (rsReportServerDatabaseUnavailable) Get Online Help Login
failed for user 'ReportServer2005'. The user is not associated with a
trusted SQL Server connection.
Ive set up ReportServer2005 as a Login on SQL Server and its been set
up as a Windows login accout.
Thanks
ChrisOn May 3, 3:26 pm, "Chris Asaipillai"
<chris.asaipil...@.btinternet.com> wrote:
> Hi there
> Im a newbie to Reporting Services and am trying it out on SQL Server 2005
> I went through the installation process for Reporting Services and installed
> a sample database from the Microsoft Press Book on Reporting Services.
> I tried to navigate to the following location :
> http://localhost/Reports/Pages/Folder.aspx
> but i get the following error message
> The report server cannot open a connection to the report
> server database. A connection to the database is required for all requests
> and processing. (rsReportServerDatabaseUnavailable) Get Online Help Login
> failed for user 'ReportServer2005'. The user is not associated with a
> trusted SQL Server connection.
> Ive set up ReportServer2005 as a Login on SQL Server and its been set
> up as a Windows login accout.
> Thanks
> Chris
I've read somewhere that the User ID and Password for SSRS might be
locked. You might want to try unlocking it and restarting IIS (via
iisreset at the command prompt). Also, check the RSConfiguration file.
Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant
Im a newbie to Reporting Services and am trying it out on SQL Server 2005
I went through the installation process for Reporting Services and installed
a sample database from the Microsoft Press Book on Reporting Services.
I tried to navigate to the following location :
http://localhost/Reports/Pages/Folder.aspx
but i get the following error message
The report server cannot open a connection to the report
server database. A connection to the database is required for all requests
and processing. (rsReportServerDatabaseUnavailable) Get Online Help Login
failed for user 'ReportServer2005'. The user is not associated with a
trusted SQL Server connection.
Ive set up ReportServer2005 as a Login on SQL Server and its been set
up as a Windows login accout.
Thanks
ChrisOn May 3, 3:26 pm, "Chris Asaipillai"
<chris.asaipil...@.btinternet.com> wrote:
> Hi there
> Im a newbie to Reporting Services and am trying it out on SQL Server 2005
> I went through the installation process for Reporting Services and installed
> a sample database from the Microsoft Press Book on Reporting Services.
> I tried to navigate to the following location :
> http://localhost/Reports/Pages/Folder.aspx
> but i get the following error message
> The report server cannot open a connection to the report
> server database. A connection to the database is required for all requests
> and processing. (rsReportServerDatabaseUnavailable) Get Online Help Login
> failed for user 'ReportServer2005'. The user is not associated with a
> trusted SQL Server connection.
> Ive set up ReportServer2005 as a Login on SQL Server and its been set
> up as a Windows login accout.
> Thanks
> Chris
I've read somewhere that the User ID and Password for SSRS might be
locked. You might want to try unlocking it and restarting IIS (via
iisreset at the command prompt). Also, check the RSConfiguration file.
Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant
Thursday, February 16, 2012
Can't install SQL Server Express 2005 in quiet mode
I'm trying to use a bootstrapper with SQL Server Express 2005, but I'm having difficulty with the installation. I'm using the command line:
SQLEXPR.EXE /qb INSTANCENAME=myInstanceName SAPWD=mySaPassword
SQLEXPR.EXE /qb INSTANCENAME=myInstanceName SAPWD=mySaPassword
and it seems to fail right at the system configuration check. One of the log files says "Error: Action "LaunchLocalBootstrapAction" threw an exception during execution. Error information reported during run: "c:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\setup.exe" finished and returned: 0"
I can post the contents of the log files if anyone needs them.Try this. Please also check the file template.ini located at the same directory for setup.exe. You can find sample command line to install SQL Server 2005 in silent mode.
start /wait setup.exe /qb ADDLOCAL=SQL_Engine INSTANCENAME="OneExpress" SQLACCOUNT="<domain\user>" SQLPASSWORD="<strong password>" SQLBROWSERACCOUNT="<domain\user>" SQLBROWSERPASSWORD="<strong password>" SQLAUTOSTART=1 SQLBROWSERAUTOSTART=1|||The following command line installs SQL Server Express 2005 in quiet mode (without any user input):
SQLEXPR.EXE /qb ADDLOCAL=ALL INSTANCENAME=myInstanceName SAPWD=mySaPassword
As you can see, the original command line I was having problems with did not include the "ADDLOCAL=ALL" option.
Can't install SQL Server 2005 Mobile Edition Server Tools Beta 1
I'm working with VS.NET 2005 Beta2 and SQL Server 2005 April CTP. My
SQL Server 2005 installation was more or less full, that is, I
installed everything related to Client Connectivity. I was bound to
build a merge replication scenario when I've noticed I needed "SQL
Server 2005 Mobile Edition Server Tools Beta 1".
Download the installer and execute it, obtaining the following error:
"You must first install the Replication Components for SQL Server 2000
SP 3a or higher or the SQL Server 2005 Client Connectivity Components."
What is the problem here if I have installed all Client components?
Any help will be greatly appreciated.
Instead of downloading "SQL Server 2005 Mobile Edition Server Tools
Beta 1" from Microsoft, which still warns me that I cannot replicate
with SQL Server 2005 because I don't have Client Connectivity
Components installed, I finally read this on MSDN2:
http://msdn2.microsoft.com/en-us/library/ms171908
The setup file is "sqlce30setupen.msi", located at "C:\Program
Files\Microsoft SQL Server\90\Tools\binn\VSShell\Common7\IDE". This
setup process went ok and did not warn me about anything.
Hope it helps people having the same problem.
PS: How does MS redirect developers to download Server Tools Beta 1 in
order to setup replication and then setup fails or warns the user
wihout any logical reason. Incredible! Can anybody explain me this?
SQL Server 2005 installation was more or less full, that is, I
installed everything related to Client Connectivity. I was bound to
build a merge replication scenario when I've noticed I needed "SQL
Server 2005 Mobile Edition Server Tools Beta 1".
Download the installer and execute it, obtaining the following error:
"You must first install the Replication Components for SQL Server 2000
SP 3a or higher or the SQL Server 2005 Client Connectivity Components."
What is the problem here if I have installed all Client components?
Any help will be greatly appreciated.
Instead of downloading "SQL Server 2005 Mobile Edition Server Tools
Beta 1" from Microsoft, which still warns me that I cannot replicate
with SQL Server 2005 because I don't have Client Connectivity
Components installed, I finally read this on MSDN2:
http://msdn2.microsoft.com/en-us/library/ms171908
The setup file is "sqlce30setupen.msi", located at "C:\Program
Files\Microsoft SQL Server\90\Tools\binn\VSShell\Common7\IDE". This
setup process went ok and did not warn me about anything.
Hope it helps people having the same problem.
PS: How does MS redirect developers to download Server Tools Beta 1 in
order to setup replication and then setup fails or warns the user
wihout any logical reason. Incredible! Can anybody explain me this?
Tuesday, February 14, 2012
Can't Install SQL Server 2000
during installation i get this error message
it's not possible to configure SQL server
Here is the last portion of the log
#####################################################
Avvio del servizio in corso ...
Latin1_General_BIN
-m -Q -T4022 -T3659
Connessione al server in corso ...
driver={sql server};server=PC-BEN;UID=sa;PWD=;database=master
[Microsoft][ODBC SQL Server Driver][Named Pipes]Connessione interrotta.
[Microsoft][ODBC SQL Server Driver][Named Pipes]ConnectionRead
(GetOverLappedResult()).
driver={sql server};server=PC-BEN;UID=sa;PWD=;database=master
[Microsoft][ODBC SQL Server Driver][Named Pipes]Connessione interrotta.
[Microsoft][ODBC SQL Server Driver][Named Pipes]ConnectionRead
(GetOverLappedResult()).
driver={sql server};server=PC-BEN;UID=sa;PWD=;database=master
[Microsoft][ODBC SQL Server Driver][Named Pipes]Connessione interrotta.
[Microsoft][ODBC SQL Server Driver][Named Pipes]ConnectionRead
(GetOverLappedResult()).
Impossibile configurare SQL Server.
#####################################################
06:40:00 Process Exit Code: (-1)
06:41:05 Impossibile configurare il server. Per ulteriori informazioni,
esaminare il log degli errori del server e C:\WINNT\sqlstp.log.
06:41:05 Action CleanUpInstall:
06:41:05 C:\DOCUME~1\ADMINI~2.PC-\IMPOST~1\Temp\SqlSetup\Bin\scm.exe
-Silent 1 -Action 4 -Service SQLSERVERAGENT
06:41:05 Process Exit Code: (1060) Il servizio specificato non esiste come
servizio installato.
06:41:05 C:\DOCUME~1\ADMINI~2.PC-\IMPOST~1\Temp\SqlSetup\Bin\scm.exe
-Silent 1 -Action 4 -Service MSSQLSERVER
06:41:05 Process Exit Code: (0)
06:41:05 StatsGenerate returned: 2
06:41:05 StatsGenerate (0x80000000,0x1,0xf000000,0x400,1040,303,0x0,0x1,0,0,0
06:41:05 StatsGenerate -1,Administrator)
06:41:05 Installation Failed.
What should I Do to finish installation without this error
Please help me
ByIs this a completely clean server. I mean is it a fresh ihstall of the OS or
has it been used as something else before?
--
Nik Marshall-Blank MCSD/MCDBA
"Ben" <Ben@.discussions.microsoft.com> wrote in message
news:318AD8D8-EA29-439C-BF74-446AD1170EDB@.microsoft.com...
> during installation i get this error message
> it's not possible to configure SQL server
> Here is the last portion of the log
> #####################################################
>
> Avvio del servizio in corso ...
> Latin1_General_BIN
> -m -Q -T4022 -T3659
> Connessione al server in corso ...
> driver={sql server};server=PC-BEN;UID=sa;PWD=;database=master
> [Microsoft][ODBC SQL Server Driver][Named Pipes]Connessione interrotta.
> [Microsoft][ODBC SQL Server Driver][Named Pipes]ConnectionRead
> (GetOverLappedResult()).
> driver={sql server};server=PC-BEN;UID=sa;PWD=;database=master
> [Microsoft][ODBC SQL Server Driver][Named Pipes]Connessione interrotta.
> [Microsoft][ODBC SQL Server Driver][Named Pipes]ConnectionRead
> (GetOverLappedResult()).
> driver={sql server};server=PC-BEN;UID=sa;PWD=;database=master
> [Microsoft][ODBC SQL Server Driver][Named Pipes]Connessione interrotta.
> [Microsoft][ODBC SQL Server Driver][Named Pipes]ConnectionRead
> (GetOverLappedResult()).
> Impossibile configurare SQL Server.
> #####################################################
> 06:40:00 Process Exit Code: (-1)
> 06:41:05 Impossibile configurare il server. Per ulteriori informazioni,
> esaminare il log degli errori del server e C:\WINNT\sqlstp.log.
> 06:41:05 Action CleanUpInstall:
> 06:41:05 C:\DOCUME~1\ADMINI~2.PC-\IMPOST~1\Temp\SqlSetup\Bin\scm.exe
> -Silent 1 -Action 4 -Service SQLSERVERAGENT
> 06:41:05 Process Exit Code: (1060) Il servizio specificato non esiste come
> servizio installato.
> 06:41:05 C:\DOCUME~1\ADMINI~2.PC-\IMPOST~1\Temp\SqlSetup\Bin\scm.exe
> -Silent 1 -Action 4 -Service MSSQLSERVER
> 06:41:05 Process Exit Code: (0)
> 06:41:05 StatsGenerate returned: 2
> 06:41:05 StatsGenerate
> (0x80000000,0x1,0xf000000,0x400,1040,303,0x0,0x1,0,0,0
> 06:41:05 StatsGenerate -1,Administrator)
> 06:41:05 Installation Failed.
> What should I Do to finish installation without this error
> Please help me
> By
it's not possible to configure SQL server
Here is the last portion of the log
#####################################################
Avvio del servizio in corso ...
Latin1_General_BIN
-m -Q -T4022 -T3659
Connessione al server in corso ...
driver={sql server};server=PC-BEN;UID=sa;PWD=;database=master
[Microsoft][ODBC SQL Server Driver][Named Pipes]Connessione interrotta.
[Microsoft][ODBC SQL Server Driver][Named Pipes]ConnectionRead
(GetOverLappedResult()).
driver={sql server};server=PC-BEN;UID=sa;PWD=;database=master
[Microsoft][ODBC SQL Server Driver][Named Pipes]Connessione interrotta.
[Microsoft][ODBC SQL Server Driver][Named Pipes]ConnectionRead
(GetOverLappedResult()).
driver={sql server};server=PC-BEN;UID=sa;PWD=;database=master
[Microsoft][ODBC SQL Server Driver][Named Pipes]Connessione interrotta.
[Microsoft][ODBC SQL Server Driver][Named Pipes]ConnectionRead
(GetOverLappedResult()).
Impossibile configurare SQL Server.
#####################################################
06:40:00 Process Exit Code: (-1)
06:41:05 Impossibile configurare il server. Per ulteriori informazioni,
esaminare il log degli errori del server e C:\WINNT\sqlstp.log.
06:41:05 Action CleanUpInstall:
06:41:05 C:\DOCUME~1\ADMINI~2.PC-\IMPOST~1\Temp\SqlSetup\Bin\scm.exe
-Silent 1 -Action 4 -Service SQLSERVERAGENT
06:41:05 Process Exit Code: (1060) Il servizio specificato non esiste come
servizio installato.
06:41:05 C:\DOCUME~1\ADMINI~2.PC-\IMPOST~1\Temp\SqlSetup\Bin\scm.exe
-Silent 1 -Action 4 -Service MSSQLSERVER
06:41:05 Process Exit Code: (0)
06:41:05 StatsGenerate returned: 2
06:41:05 StatsGenerate (0x80000000,0x1,0xf000000,0x400,1040,303,0x0,0x1,0,0,0
06:41:05 StatsGenerate -1,Administrator)
06:41:05 Installation Failed.
What should I Do to finish installation without this error
Please help me
ByIs this a completely clean server. I mean is it a fresh ihstall of the OS or
has it been used as something else before?
--
Nik Marshall-Blank MCSD/MCDBA
"Ben" <Ben@.discussions.microsoft.com> wrote in message
news:318AD8D8-EA29-439C-BF74-446AD1170EDB@.microsoft.com...
> during installation i get this error message
> it's not possible to configure SQL server
> Here is the last portion of the log
> #####################################################
>
> Avvio del servizio in corso ...
> Latin1_General_BIN
> -m -Q -T4022 -T3659
> Connessione al server in corso ...
> driver={sql server};server=PC-BEN;UID=sa;PWD=;database=master
> [Microsoft][ODBC SQL Server Driver][Named Pipes]Connessione interrotta.
> [Microsoft][ODBC SQL Server Driver][Named Pipes]ConnectionRead
> (GetOverLappedResult()).
> driver={sql server};server=PC-BEN;UID=sa;PWD=;database=master
> [Microsoft][ODBC SQL Server Driver][Named Pipes]Connessione interrotta.
> [Microsoft][ODBC SQL Server Driver][Named Pipes]ConnectionRead
> (GetOverLappedResult()).
> driver={sql server};server=PC-BEN;UID=sa;PWD=;database=master
> [Microsoft][ODBC SQL Server Driver][Named Pipes]Connessione interrotta.
> [Microsoft][ODBC SQL Server Driver][Named Pipes]ConnectionRead
> (GetOverLappedResult()).
> Impossibile configurare SQL Server.
> #####################################################
> 06:40:00 Process Exit Code: (-1)
> 06:41:05 Impossibile configurare il server. Per ulteriori informazioni,
> esaminare il log degli errori del server e C:\WINNT\sqlstp.log.
> 06:41:05 Action CleanUpInstall:
> 06:41:05 C:\DOCUME~1\ADMINI~2.PC-\IMPOST~1\Temp\SqlSetup\Bin\scm.exe
> -Silent 1 -Action 4 -Service SQLSERVERAGENT
> 06:41:05 Process Exit Code: (1060) Il servizio specificato non esiste come
> servizio installato.
> 06:41:05 C:\DOCUME~1\ADMINI~2.PC-\IMPOST~1\Temp\SqlSetup\Bin\scm.exe
> -Silent 1 -Action 4 -Service MSSQLSERVER
> 06:41:05 Process Exit Code: (0)
> 06:41:05 StatsGenerate returned: 2
> 06:41:05 StatsGenerate
> (0x80000000,0x1,0xf000000,0x400,1040,303,0x0,0x1,0,0,0
> 06:41:05 StatsGenerate -1,Administrator)
> 06:41:05 Installation Failed.
> What should I Do to finish installation without this error
> Please help me
> By
Can't Install SQL Server 2000
during installation i get this error message
it's not possible to configure SQL server
Here is the last portion of the log
################################################## ###
Avvio del servizio in corso ...
Latin1_General_BIN
-m -Q -T4022 -T3659
Connessione al server in corso ...
driver={sql server};server=PC-BEN;UID=sa;PWD=;database=master
[Microsoft][ODBC SQL Server Driver][Named Pipes]Connessione interrotta.
[Microsoft][ODBC SQL Server Driver][Named Pipes]ConnectionRead
(GetOverLappedResult()).
driver={sql server};server=PC-BEN;UID=sa;PWD=;database=master
[Microsoft][ODBC SQL Server Driver][Named Pipes]Connessione interrotta.
[Microsoft][ODBC SQL Server Driver][Named Pipes]ConnectionRead
(GetOverLappedResult()).
driver={sql server};server=PC-BEN;UID=sa;PWD=;database=master
[Microsoft][ODBC SQL Server Driver][Named Pipes]Connessione interrotta.
[Microsoft][ODBC SQL Server Driver][Named Pipes]ConnectionRead
(GetOverLappedResult()).
Impossibile configurare SQL Server.
################################################## ###
06:40:00 Process Exit Code: (-1)
06:41:05 Impossibile configurare il server. Per ulteriori informazioni,
esaminare il log degli errori del server e C:\WINNT\sqlstp.log.
06:41:05 Action CleanUpInstall:
06:41:05 C:\DOCUME~1\ADMINI~2.PC-\IMPOST~1\Temp\SqlSetup\Bin\scm.exe
-Silent 1 -Action 4 -Service SQLSERVERAGENT
06:41:05 Process Exit Code: (1060) Il servizio specificato non esiste come
servizio installato.
06:41:05 C:\DOCUME~1\ADMINI~2.PC-\IMPOST~1\Temp\SqlSetup\Bin\scm.exe
-Silent 1 -Action 4 -Service MSSQLSERVER
06:41:05 Process Exit Code: (0)
06:41:05 StatsGenerate returned: 2
06:41:05 StatsGenerate (0x80000000,0x1,0xf000000,0x400,1040,303,0x0,0x1,0 ,0,0
06:41:05 StatsGenerate -1,Administrator)
06:41:05 Installation Failed.
What should I Do to finish installation without this error
Please help me
By
Is this a completely clean server. I mean is it a fresh ihstall of the OS or
has it been used as something else before?
Nik Marshall-Blank MCSD/MCDBA
"Ben" <Ben@.discussions.microsoft.com> wrote in message
news:318AD8D8-EA29-439C-BF74-446AD1170EDB@.microsoft.com...
> during installation i get this error message
> it's not possible to configure SQL server
> Here is the last portion of the log
> ################################################## ###
>
> Avvio del servizio in corso ...
> Latin1_General_BIN
> -m -Q -T4022 -T3659
> Connessione al server in corso ...
> driver={sql server};server=PC-BEN;UID=sa;PWD=;database=master
> [Microsoft][ODBC SQL Server Driver][Named Pipes]Connessione interrotta.
> [Microsoft][ODBC SQL Server Driver][Named Pipes]ConnectionRead
> (GetOverLappedResult()).
> driver={sql server};server=PC-BEN;UID=sa;PWD=;database=master
> [Microsoft][ODBC SQL Server Driver][Named Pipes]Connessione interrotta.
> [Microsoft][ODBC SQL Server Driver][Named Pipes]ConnectionRead
> (GetOverLappedResult()).
> driver={sql server};server=PC-BEN;UID=sa;PWD=;database=master
> [Microsoft][ODBC SQL Server Driver][Named Pipes]Connessione interrotta.
> [Microsoft][ODBC SQL Server Driver][Named Pipes]ConnectionRead
> (GetOverLappedResult()).
> Impossibile configurare SQL Server.
> ################################################## ###
> 06:40:00 Process Exit Code: (-1)
> 06:41:05 Impossibile configurare il server. Per ulteriori informazioni,
> esaminare il log degli errori del server e C:\WINNT\sqlstp.log.
> 06:41:05 Action CleanUpInstall:
> 06:41:05 C:\DOCUME~1\ADMINI~2.PC-\IMPOST~1\Temp\SqlSetup\Bin\scm.exe
> -Silent 1 -Action 4 -Service SQLSERVERAGENT
> 06:41:05 Process Exit Code: (1060) Il servizio specificato non esiste come
> servizio installato.
> 06:41:05 C:\DOCUME~1\ADMINI~2.PC-\IMPOST~1\Temp\SqlSetup\Bin\scm.exe
> -Silent 1 -Action 4 -Service MSSQLSERVER
> 06:41:05 Process Exit Code: (0)
> 06:41:05 StatsGenerate returned: 2
> 06:41:05 StatsGenerate
> (0x80000000,0x1,0xf000000,0x400,1040,303,0x0,0x1,0 ,0,0
> 06:41:05 StatsGenerate -1,Administrator)
> 06:41:05 Installation Failed.
> What should I Do to finish installation without this error
> Please help me
> By
it's not possible to configure SQL server
Here is the last portion of the log
################################################## ###
Avvio del servizio in corso ...
Latin1_General_BIN
-m -Q -T4022 -T3659
Connessione al server in corso ...
driver={sql server};server=PC-BEN;UID=sa;PWD=;database=master
[Microsoft][ODBC SQL Server Driver][Named Pipes]Connessione interrotta.
[Microsoft][ODBC SQL Server Driver][Named Pipes]ConnectionRead
(GetOverLappedResult()).
driver={sql server};server=PC-BEN;UID=sa;PWD=;database=master
[Microsoft][ODBC SQL Server Driver][Named Pipes]Connessione interrotta.
[Microsoft][ODBC SQL Server Driver][Named Pipes]ConnectionRead
(GetOverLappedResult()).
driver={sql server};server=PC-BEN;UID=sa;PWD=;database=master
[Microsoft][ODBC SQL Server Driver][Named Pipes]Connessione interrotta.
[Microsoft][ODBC SQL Server Driver][Named Pipes]ConnectionRead
(GetOverLappedResult()).
Impossibile configurare SQL Server.
################################################## ###
06:40:00 Process Exit Code: (-1)
06:41:05 Impossibile configurare il server. Per ulteriori informazioni,
esaminare il log degli errori del server e C:\WINNT\sqlstp.log.
06:41:05 Action CleanUpInstall:
06:41:05 C:\DOCUME~1\ADMINI~2.PC-\IMPOST~1\Temp\SqlSetup\Bin\scm.exe
-Silent 1 -Action 4 -Service SQLSERVERAGENT
06:41:05 Process Exit Code: (1060) Il servizio specificato non esiste come
servizio installato.
06:41:05 C:\DOCUME~1\ADMINI~2.PC-\IMPOST~1\Temp\SqlSetup\Bin\scm.exe
-Silent 1 -Action 4 -Service MSSQLSERVER
06:41:05 Process Exit Code: (0)
06:41:05 StatsGenerate returned: 2
06:41:05 StatsGenerate (0x80000000,0x1,0xf000000,0x400,1040,303,0x0,0x1,0 ,0,0
06:41:05 StatsGenerate -1,Administrator)
06:41:05 Installation Failed.
What should I Do to finish installation without this error
Please help me
By
Is this a completely clean server. I mean is it a fresh ihstall of the OS or
has it been used as something else before?
Nik Marshall-Blank MCSD/MCDBA
"Ben" <Ben@.discussions.microsoft.com> wrote in message
news:318AD8D8-EA29-439C-BF74-446AD1170EDB@.microsoft.com...
> during installation i get this error message
> it's not possible to configure SQL server
> Here is the last portion of the log
> ################################################## ###
>
> Avvio del servizio in corso ...
> Latin1_General_BIN
> -m -Q -T4022 -T3659
> Connessione al server in corso ...
> driver={sql server};server=PC-BEN;UID=sa;PWD=;database=master
> [Microsoft][ODBC SQL Server Driver][Named Pipes]Connessione interrotta.
> [Microsoft][ODBC SQL Server Driver][Named Pipes]ConnectionRead
> (GetOverLappedResult()).
> driver={sql server};server=PC-BEN;UID=sa;PWD=;database=master
> [Microsoft][ODBC SQL Server Driver][Named Pipes]Connessione interrotta.
> [Microsoft][ODBC SQL Server Driver][Named Pipes]ConnectionRead
> (GetOverLappedResult()).
> driver={sql server};server=PC-BEN;UID=sa;PWD=;database=master
> [Microsoft][ODBC SQL Server Driver][Named Pipes]Connessione interrotta.
> [Microsoft][ODBC SQL Server Driver][Named Pipes]ConnectionRead
> (GetOverLappedResult()).
> Impossibile configurare SQL Server.
> ################################################## ###
> 06:40:00 Process Exit Code: (-1)
> 06:41:05 Impossibile configurare il server. Per ulteriori informazioni,
> esaminare il log degli errori del server e C:\WINNT\sqlstp.log.
> 06:41:05 Action CleanUpInstall:
> 06:41:05 C:\DOCUME~1\ADMINI~2.PC-\IMPOST~1\Temp\SqlSetup\Bin\scm.exe
> -Silent 1 -Action 4 -Service SQLSERVERAGENT
> 06:41:05 Process Exit Code: (1060) Il servizio specificato non esiste come
> servizio installato.
> 06:41:05 C:\DOCUME~1\ADMINI~2.PC-\IMPOST~1\Temp\SqlSetup\Bin\scm.exe
> -Silent 1 -Action 4 -Service MSSQLSERVER
> 06:41:05 Process Exit Code: (0)
> 06:41:05 StatsGenerate returned: 2
> 06:41:05 StatsGenerate
> (0x80000000,0x1,0xf000000,0x400,1040,303,0x0,0x1,0 ,0,0
> 06:41:05 StatsGenerate -1,Administrator)
> 06:41:05 Installation Failed.
> What should I Do to finish installation without this error
> Please help me
> By
Can't Install SQL Server 2000
during installation i get this error message
it's not possible to configure SQL server
Here is the last portion of the log
########################################
#############
Avvio del servizio in corso ...
Latin1_General_BIN
-m -Q -T4022 -T3659
Connessione al server in corso ...
driver={sql server};server=PC-BEN;UID=sa;PWD=;database=master
[Microsoft][ODBC SQL Server Driver][Named Pipes]Connessione inte
rrotta.
[Microsoft][ODBC SQL Server Driver][Named Pipes]ConnectionRead
(GetOverLappedResult()).
driver={sql server};server=PC-BEN;UID=sa;PWD=;database=master
[Microsoft][ODBC SQL Server Driver][Named Pipes]Connessione inte
rrotta.
[Microsoft][ODBC SQL Server Driver][Named Pipes]ConnectionRead
(GetOverLappedResult()).
driver={sql server};server=PC-BEN;UID=sa;PWD=;database=master
[Microsoft][ODBC SQL Server Driver][Named Pipes]Connessione inte
rrotta.
[Microsoft][ODBC SQL Server Driver][Named Pipes]ConnectionRead
(GetOverLappedResult()).
Impossibile configurare SQL Server.
########################################
#############
06:40:00 Process Exit Code: (-1)
06:41:05 Impossibile configurare il server. Per ulteriori informazioni,
esaminare il log degli errori del server e C:\WINNT\sqlstp.log.
06:41:05 Action CleanUpInstall:
06:41:05 C:\DOCUME~1\ADMINI~2.PC-\IMPOST~1\Temp\SqlSetup\Bin\scm.exe
-Silent 1 -Action 4 -Service SQLSERVERAGENT
06:41:05 Process Exit Code: (1060) Il servizio specificato non esiste come
servizio installato.
06:41:05 C:\DOCUME~1\ADMINI~2.PC-\IMPOST~1\Temp\SqlSetup\Bin\scm.exe
-Silent 1 -Action 4 -Service MSSQLSERVER
06:41:05 Process Exit Code: (0)
06:41:05 StatsGenerate returned: 2
06:41:05 StatsGenerate (0x80000000,0x1,0xf000000,0x400,1040,303
,0x0,0x1,0,0,
0
06:41:05 StatsGenerate -1,Administrator)
06:41:05 Installation Failed.
What should I Do to finish installation without this error
Please help me
ByIs this a completely clean server. I mean is it a fresh ihstall of the OS or
has it been used as something else before?
Nik Marshall-Blank MCSD/MCDBA
"Ben" <Ben@.discussions.microsoft.com> wrote in message
news:318AD8D8-EA29-439C-BF74-446AD1170EDB@.microsoft.com...
> during installation i get this error message
> it's not possible to configure SQL server
> Here is the last portion of the log
> ########################################
#############
>
> Avvio del servizio in corso ...
> Latin1_General_BIN
> -m -Q -T4022 -T3659
> Connessione al server in corso ...
> driver={sql server};server=PC-BEN;UID=sa;PWD=;database=master
> [Microsoft][ODBC SQL Server Driver][Named Pipes]Connessione in
terrotta.
> [Microsoft][ODBC SQL Server Driver][Named Pipes]ConnectionRead
> (GetOverLappedResult()).
> driver={sql server};server=PC-BEN;UID=sa;PWD=;database=master
> [Microsoft][ODBC SQL Server Driver][Named Pipes]Connessione in
terrotta.
> [Microsoft][ODBC SQL Server Driver][Named Pipes]ConnectionRead
> (GetOverLappedResult()).
> driver={sql server};server=PC-BEN;UID=sa;PWD=;database=master
> [Microsoft][ODBC SQL Server Driver][Named Pipes]Connessione in
terrotta.
> [Microsoft][ODBC SQL Server Driver][Named Pipes]ConnectionRead
> (GetOverLappedResult()).
> Impossibile configurare SQL Server.
> ########################################
#############
> 06:40:00 Process Exit Code: (-1)
> 06:41:05 Impossibile configurare il server. Per ulteriori informazioni,
> esaminare il log degli errori del server e C:\WINNT\sqlstp.log.
> 06:41:05 Action CleanUpInstall:
> 06:41:05 C:\DOCUME~1\ADMINI~2.PC-\IMPOST~1\Temp\SqlSetup\Bin\scm.exe
> -Silent 1 -Action 4 -Service SQLSERVERAGENT
> 06:41:05 Process Exit Code: (1060) Il servizio specificato non esiste come
> servizio installato.
> 06:41:05 C:\DOCUME~1\ADMINI~2.PC-\IMPOST~1\Temp\SqlSetup\Bin\scm.exe
> -Silent 1 -Action 4 -Service MSSQLSERVER
> 06:41:05 Process Exit Code: (0)
> 06:41:05 StatsGenerate returned: 2
> 06:41:05 StatsGenerate
> (0x80000000,0x1,0xf000000,0x400,1040,303
,0x0,0x1,0,0,0
> 06:41:05 StatsGenerate -1,Administrator)
> 06:41:05 Installation Failed.
> What should I Do to finish installation without this error
> Please help me
> By
it's not possible to configure SQL server
Here is the last portion of the log
########################################
#############
Avvio del servizio in corso ...
Latin1_General_BIN
-m -Q -T4022 -T3659
Connessione al server in corso ...
driver={sql server};server=PC-BEN;UID=sa;PWD=;database=master
[Microsoft][ODBC SQL Server Driver][Named Pipes]Connessione inte
rrotta.
[Microsoft][ODBC SQL Server Driver][Named Pipes]ConnectionRead
(GetOverLappedResult()).
driver={sql server};server=PC-BEN;UID=sa;PWD=;database=master
[Microsoft][ODBC SQL Server Driver][Named Pipes]Connessione inte
rrotta.
[Microsoft][ODBC SQL Server Driver][Named Pipes]ConnectionRead
(GetOverLappedResult()).
driver={sql server};server=PC-BEN;UID=sa;PWD=;database=master
[Microsoft][ODBC SQL Server Driver][Named Pipes]Connessione inte
rrotta.
[Microsoft][ODBC SQL Server Driver][Named Pipes]ConnectionRead
(GetOverLappedResult()).
Impossibile configurare SQL Server.
########################################
#############
06:40:00 Process Exit Code: (-1)
06:41:05 Impossibile configurare il server. Per ulteriori informazioni,
esaminare il log degli errori del server e C:\WINNT\sqlstp.log.
06:41:05 Action CleanUpInstall:
06:41:05 C:\DOCUME~1\ADMINI~2.PC-\IMPOST~1\Temp\SqlSetup\Bin\scm.exe
-Silent 1 -Action 4 -Service SQLSERVERAGENT
06:41:05 Process Exit Code: (1060) Il servizio specificato non esiste come
servizio installato.
06:41:05 C:\DOCUME~1\ADMINI~2.PC-\IMPOST~1\Temp\SqlSetup\Bin\scm.exe
-Silent 1 -Action 4 -Service MSSQLSERVER
06:41:05 Process Exit Code: (0)
06:41:05 StatsGenerate returned: 2
06:41:05 StatsGenerate (0x80000000,0x1,0xf000000,0x400,1040,303
,0x0,0x1,0,0,
0
06:41:05 StatsGenerate -1,Administrator)
06:41:05 Installation Failed.
What should I Do to finish installation without this error
Please help me
ByIs this a completely clean server. I mean is it a fresh ihstall of the OS or
has it been used as something else before?
Nik Marshall-Blank MCSD/MCDBA
"Ben" <Ben@.discussions.microsoft.com> wrote in message
news:318AD8D8-EA29-439C-BF74-446AD1170EDB@.microsoft.com...
> during installation i get this error message
> it's not possible to configure SQL server
> Here is the last portion of the log
> ########################################
#############
>
> Avvio del servizio in corso ...
> Latin1_General_BIN
> -m -Q -T4022 -T3659
> Connessione al server in corso ...
> driver={sql server};server=PC-BEN;UID=sa;PWD=;database=master
> [Microsoft][ODBC SQL Server Driver][Named Pipes]Connessione in
terrotta.
> [Microsoft][ODBC SQL Server Driver][Named Pipes]ConnectionRead
> (GetOverLappedResult()).
> driver={sql server};server=PC-BEN;UID=sa;PWD=;database=master
> [Microsoft][ODBC SQL Server Driver][Named Pipes]Connessione in
terrotta.
> [Microsoft][ODBC SQL Server Driver][Named Pipes]ConnectionRead
> (GetOverLappedResult()).
> driver={sql server};server=PC-BEN;UID=sa;PWD=;database=master
> [Microsoft][ODBC SQL Server Driver][Named Pipes]Connessione in
terrotta.
> [Microsoft][ODBC SQL Server Driver][Named Pipes]ConnectionRead
> (GetOverLappedResult()).
> Impossibile configurare SQL Server.
> ########################################
#############
> 06:40:00 Process Exit Code: (-1)
> 06:41:05 Impossibile configurare il server. Per ulteriori informazioni,
> esaminare il log degli errori del server e C:\WINNT\sqlstp.log.
> 06:41:05 Action CleanUpInstall:
> 06:41:05 C:\DOCUME~1\ADMINI~2.PC-\IMPOST~1\Temp\SqlSetup\Bin\scm.exe
> -Silent 1 -Action 4 -Service SQLSERVERAGENT
> 06:41:05 Process Exit Code: (1060) Il servizio specificato non esiste come
> servizio installato.
> 06:41:05 C:\DOCUME~1\ADMINI~2.PC-\IMPOST~1\Temp\SqlSetup\Bin\scm.exe
> -Silent 1 -Action 4 -Service MSSQLSERVER
> 06:41:05 Process Exit Code: (0)
> 06:41:05 StatsGenerate returned: 2
> 06:41:05 StatsGenerate
> (0x80000000,0x1,0xf000000,0x400,1040,303
,0x0,0x1,0,0,0
> 06:41:05 StatsGenerate -1,Administrator)
> 06:41:05 Installation Failed.
> What should I Do to finish installation without this error
> Please help me
> By
Can't install RS 2000
I am trying to install RS 2000 on my local SQL 2000 that runs on XP Pro.
I am getting an error after installation verifies credentials. The error
says something about a wrong version of RS I am trying to install. I have
tried Ent, Dev, and Stand versions. Only Dev version gets to the point of
the error. What is a solution of that problem?
ThanksWhat version of SQL 2000 do you have installed? I've had an issue where I
have tried to install RS (Standard) with SQL 2000 (Dev). Make sure the
versions are compatible.
"Mark Goldin" wrote:
> I am trying to install RS 2000 on my local SQL 2000 that runs on XP Pro.
> I am getting an error after installation verifies credentials. The error
> says something about a wrong version of RS I am trying to install. I have
> tried Ent, Dev, and Stand versions. Only Dev version gets to the point of
> the error. What is a solution of that problem?
> Thanks
>
>
I am getting an error after installation verifies credentials. The error
says something about a wrong version of RS I am trying to install. I have
tried Ent, Dev, and Stand versions. Only Dev version gets to the point of
the error. What is a solution of that problem?
ThanksWhat version of SQL 2000 do you have installed? I've had an issue where I
have tried to install RS (Standard) with SQL 2000 (Dev). Make sure the
versions are compatible.
"Mark Goldin" wrote:
> I am trying to install RS 2000 on my local SQL 2000 that runs on XP Pro.
> I am getting an error after installation verifies credentials. The error
> says something about a wrong version of RS I am trying to install. I have
> tried Ent, Dev, and Stand versions. Only Dev version gets to the point of
> the error. What is a solution of that problem?
> Thanks
>
>
Can't install MSDE on Windows XP
Hello,
I can't install MSDE on a computer running Windows XP. The installation stop
and, in the error log, I have the following error message
Executing "C:\Program Files\Microsoft SQL
Server\80\Tools\Binn\cnfgsvr.exe -V 1 -M 1 -U sa -I "MILORD" -Q
"French_CI_AS""
MSI (s) (00!E4) [16:24:27:625]: Product : Microsoft SQL Server Desktop
Engine (MILORD) -- The installation program can't configure the server. Look
at the server error and installation logs for more informations
MSI (c) (5C:B4) [16:24:17:890]: Font created. Charset: Req=0, Ret=0, Font:
Req=MS Shell Dlg, Ret=MS Shell Dlg
The installation program can't configure the server. Look at the server
error and installation logs for more informations
MSI (s) (00:08) [16:24:27:703]: User policy value 'DisableRollback' is 0
MSI (s) (00:08) [16:24:27:703]: Machine policy value 'DisableRollback' is 0
End of action 16:24:27 : InstallFinalize. Return value : 3
This is the first time I see this kind of error and I have found nothing
about it. I hope someone knows about it :-)
P.S. : sorry for me bad english, I'm not really good with foreign language
^^
hi David,
David G. wrote:
> Hello,
> I can't install MSDE on a computer running Windows XP. The
> installation stop and, in the error log, I have the following error
> message
> Executing "C:\Program Files\Microsoft SQL
> Server\80\Tools\Binn\cnfgsvr.exe -V 1 -M 1 -U sa -I "MILORD" -Q
> "French_CI_AS""
> MSI (s) (00!E4) [16:24:27:625]: Product : Microsoft SQL Server Desktop
> Engine (MILORD) -- The installation program can't configure the
> server. Look at the server error and installation logs for more
> informations MSI (c) (5C:B4) [16:24:17:890]: Font created. Charset:
> Req=0, Ret=0,
> Font: Req=MS Shell Dlg, Ret=MS Shell Dlg
> The installation program can't configure the server. Look at the
> server error and installation logs for more informations
please have a look at
http://support.microsoft.com/default...99&Product=sql
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.18.0 - DbaMgr ver 0.62.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||Thanks, I will give it a look asap.
Andrea Montanari wrote:
> please have a look at
> http://support.microsoft.com/default...99&Product=sql
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
> DbaMgr2k ver 0.18.0 - DbaMgr ver 0.62.0
> (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
> interface)
> -- remove DMO to reply
I can't install MSDE on a computer running Windows XP. The installation stop
and, in the error log, I have the following error message
Executing "C:\Program Files\Microsoft SQL
Server\80\Tools\Binn\cnfgsvr.exe -V 1 -M 1 -U sa -I "MILORD" -Q
"French_CI_AS""
MSI (s) (00!E4) [16:24:27:625]: Product : Microsoft SQL Server Desktop
Engine (MILORD) -- The installation program can't configure the server. Look
at the server error and installation logs for more informations
MSI (c) (5C:B4) [16:24:17:890]: Font created. Charset: Req=0, Ret=0, Font:
Req=MS Shell Dlg, Ret=MS Shell Dlg
The installation program can't configure the server. Look at the server
error and installation logs for more informations
MSI (s) (00:08) [16:24:27:703]: User policy value 'DisableRollback' is 0
MSI (s) (00:08) [16:24:27:703]: Machine policy value 'DisableRollback' is 0
End of action 16:24:27 : InstallFinalize. Return value : 3
This is the first time I see this kind of error and I have found nothing
about it. I hope someone knows about it :-)
P.S. : sorry for me bad english, I'm not really good with foreign language
^^
hi David,
David G. wrote:
> Hello,
> I can't install MSDE on a computer running Windows XP. The
> installation stop and, in the error log, I have the following error
> message
> Executing "C:\Program Files\Microsoft SQL
> Server\80\Tools\Binn\cnfgsvr.exe -V 1 -M 1 -U sa -I "MILORD" -Q
> "French_CI_AS""
> MSI (s) (00!E4) [16:24:27:625]: Product : Microsoft SQL Server Desktop
> Engine (MILORD) -- The installation program can't configure the
> server. Look at the server error and installation logs for more
> informations MSI (c) (5C:B4) [16:24:17:890]: Font created. Charset:
> Req=0, Ret=0,
> Font: Req=MS Shell Dlg, Ret=MS Shell Dlg
> The installation program can't configure the server. Look at the
> server error and installation logs for more informations
please have a look at
http://support.microsoft.com/default...99&Product=sql
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.18.0 - DbaMgr ver 0.62.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||Thanks, I will give it a look asap.
Andrea Montanari wrote:
> please have a look at
> http://support.microsoft.com/default...99&Product=sql
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
> DbaMgr2k ver 0.18.0 - DbaMgr ver 0.62.0
> (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
> interface)
> -- remove DMO to reply
Subscribe to:
Posts (Atom)