Hello,
I am doing some development for a client who has an IIS server running
webmail on the same box as the SQL server 2000 sp3 install. I am trying to connect to
this box but do not know how to set it up to connect. The IIS for SQL server
tool lets me add a virtual directory just fine but will not connect. This
problem is not firewall based, as the 1433 port is open, and the database is
running just fine, as those in the LAN can connect ok. My problem is with
the 'external' face and my concern that the running IIS process is
preventing web-based connection. How do I modify/change the IIS for SQL
virtual directory to respond?
If you need more information, please let me know.
Thanks,
Donald Wheeler
What error do you get when you attempt to connect?
Rand
This posting is provided "as is" with no warranties and confers no rights.
|||I get the standard server not found or access denied error - both via ASP calls and the SQL Server Query analyzer. I don't think that it's an authentication problem because I've tried using both valid and invalid passwords, as well as trying to the connec
t to the Northwind database, and received the same error
Donald
|||Just to clarify, I am trying to enable web access to a SQL Server 2k sp3 database on a machine that already has a set of active IIS directories for webmail. I think the firewall is ok but the connections are getting 'swallowed' by the active IIS and not h
itting the SQL server - does this make sense and if so, how may I remedy it?
Thanks,
Donald Wheeler
sql
Showing posts with label install. Show all posts
Showing posts with label install. Show all posts
Friday, March 30, 2012
Problems installing/accessing SQL server via web
Hello,
I am doing some development for a client who has an IIS server running
webmail on the same box as the SQL server 2000 sp3 install. I am trying to c
onnect to
this box but do not know how to set it up to connect. The IIS for SQL server
tool lets me add a virtual directory just fine but will not connect. This
problem is not firewall based, as the 1433 port is open, and the database is
running just fine, as those in the LAN can connect ok. My problem is with
the 'external' face and my concern that the running IIS process is
preventing web-based connection. How do I modify/change the IIS for SQL
virtual directory to respond?
If you need more information, please let me know.
Thanks,
Donald WheelerWhat error do you get when you attempt to connect?
Rand
This posting is provided "as is" with no warranties and confers no rights.|||I get the standard server not found or access denied error - both via ASP ca
lls and the SQL Server Query analyzer. I don't think that it's an authentica
tion problem because I've tried using both valid and invalid passwords, as w
ell as trying to the connec
t to the Northwind database, and received the same error
Donald|||Just to clarify, I am trying to enable web access to a SQL Server 2k sp3 dat
abase on a machine that already has a set of active IIS directories for webm
ail. I think the firewall is ok but the connections are getting 'swallowed'
by the active IIS and not h
itting the SQL server - does this make sense and if so, how may I remedy it?
Thanks,
Donald Wheeler
I am doing some development for a client who has an IIS server running
webmail on the same box as the SQL server 2000 sp3 install. I am trying to c
onnect to
this box but do not know how to set it up to connect. The IIS for SQL server
tool lets me add a virtual directory just fine but will not connect. This
problem is not firewall based, as the 1433 port is open, and the database is
running just fine, as those in the LAN can connect ok. My problem is with
the 'external' face and my concern that the running IIS process is
preventing web-based connection. How do I modify/change the IIS for SQL
virtual directory to respond?
If you need more information, please let me know.
Thanks,
Donald WheelerWhat error do you get when you attempt to connect?
Rand
This posting is provided "as is" with no warranties and confers no rights.|||I get the standard server not found or access denied error - both via ASP ca
lls and the SQL Server Query analyzer. I don't think that it's an authentica
tion problem because I've tried using both valid and invalid passwords, as w
ell as trying to the connec
t to the Northwind database, and received the same error
Donald|||Just to clarify, I am trying to enable web access to a SQL Server 2k sp3 dat
abase on a machine that already has a set of active IIS directories for webm
ail. I think the firewall is ok but the connections are getting 'swallowed'
by the active IIS and not h
itting the SQL server - does this make sense and if so, how may I remedy it?
Thanks,
Donald Wheeler
Problems installing SRS
I'm trying to install Reporting Services on a new XP Pro SP2 IIS 6
development box. The local database is SQL Server 2000 sp3.
At the end of the installation I get an error message indicating that
the 'Setup could not initialize the report server' and that I'll have
to manually initialize the Report Server.
After running rsactive I got the message indicating that the "Report
Server Web Service has not generated a public key".
Looking in the log files is less-than-helpful (hundreds of lines
indicating that some -unknown- file is missing):
===============================================================================
aspnet_wp!library!a4!12/01/2004-10:15:58:: e ERROR: Throwing
Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
An internal error occurred on the report server. See the error log for
more details., ;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
An internal error occurred on the report server. See the error log for
more details. --> System.IO.FileNotFoundException: The system cannot
find the file specified.
at System.Runtime.InteropServices.Marshal.ThrowExceptionForHR(Int32
errorCode, IntPtr errorInfo)
at RSManagedCrypto.RSCrypto.ExportPublicKey()
at Microsoft.ReportingServices.Library.ConnectionManager.GetEncryptionKey()
at Microsoft.ReportingServices.Library.ConnectionManager.ConnectStorage()
at Microsoft.ReportingServices.Library.ConnectionManager.VerifyConnection()
at Microsoft.ReportingServices.Library.ConnectionManager.get_Connection()
at Microsoft.ReportingServices.Library.Storage.get_Connection()
at Microsoft.ReportingServices.Library.Storage.NewStandardSqlCommand(String
storedProcedureName)
at Microsoft.ReportingServices.Library.DBInterface.GetOneConfigurationInfo(String
key)
at Microsoft.ReportingServices.Library.CachedSystemProperties.GetSystemProperty(String
name)
at Microsoft.ReportingServices.Library.CachedSystemProperties.Get(String
name)
at Microsoft.ReportingServices.Library.CachedSystemProperties.GetParameter(String
name)
at Microsoft.ReportingServices.Library.RSService.get_MyReportsEnabled()
at Microsoft.ReportingServices.Library.RSService.PathToInternal(String
source)
at Microsoft.ReportingServices.Diagnostics.CatalogItemContext.SetPath(String
path, Boolean validate, Boolean convert, Boolean translate)
at Microsoft.ReportingServices.Diagnostics.CatalogItemContext.SetPath(String
path)
at Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPageContent()
at Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPage()
-- End of inner exception stack trace --
a
===============================================================================
When I navigate to the http://localhost/ReportServer I get the
following error message:
An internal error occurred on the report server. (again not very
helpful).
IIS is listening on port 80 (and there are no other apps on the port).
SO... I'm running out of things to try and patience. Is there anyone
out there who can help me get over this problem? I really need to
get this installed ASAP and there doesn't seem to be any documentation
anywhere that explains what is going wrong!!!
Any help appreciated.
GlennAfter much trail-and-error and finally a call to Microsoft I was able to
install the SRS and get everything working. I'm posting this in hopes that my
solution will help someone in a similar situation.
Ultimately the problem was solved by:
1) accessing the machine.config file
2) find the user name in the process model section (by default it's set
to 'machine')
3) change this to 'system' (temporarily)
4) using EnterpriseManager open the Keys table of the ReportServer
database (three are probably 2 keys)
5) delete the NON-ZERO key (don't delete the ZERO key)
6) browse to http:/localhost/ReportServer (should no longer produce any
errors!!!)
7) browse to http:/localhost/Reposrts
Hope this helps...
Glenn
"Glenn" wrote:
> I'm trying to install Reporting Services on a new XP Pro SP2 IIS 6
> development box. The local database is SQL Server 2000 sp3.
> At the end of the installation I get an error message indicating that
> the 'Setup could not initialize the report server' and that I'll have
> to manually initialize the Report Server.
> After running rsactive I got the message indicating that the "Report
> Server Web Service has not generated a public key".
> Looking in the log files is less-than-helpful (hundreds of lines
> indicating that some -unknown- file is missing):
> ===============================================================================> aspnet_wp!library!a4!12/01/2004-10:15:58:: e ERROR: Throwing
> Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
> An internal error occurred on the report server. See the error log for
> more details., ;
> Info: Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
> An internal error occurred on the report server. See the error log for
> more details. --> System.IO.FileNotFoundException: The system cannot
> find the file specified.
> at System.Runtime.InteropServices.Marshal.ThrowExceptionForHR(Int32
> errorCode, IntPtr errorInfo)
> at RSManagedCrypto.RSCrypto.ExportPublicKey()
> at Microsoft.ReportingServices.Library.ConnectionManager.GetEncryptionKey()
> at Microsoft.ReportingServices.Library.ConnectionManager.ConnectStorage()
> at Microsoft.ReportingServices.Library.ConnectionManager.VerifyConnection()
> at Microsoft.ReportingServices.Library.ConnectionManager.get_Connection()
> at Microsoft.ReportingServices.Library.Storage.get_Connection()
> at Microsoft.ReportingServices.Library.Storage.NewStandardSqlCommand(String
> storedProcedureName)
> at Microsoft.ReportingServices.Library.DBInterface.GetOneConfigurationInfo(String
> key)
> at Microsoft.ReportingServices.Library.CachedSystemProperties.GetSystemProperty(String
> name)
> at Microsoft.ReportingServices.Library.CachedSystemProperties.Get(String
> name)
> at Microsoft.ReportingServices.Library.CachedSystemProperties.GetParameter(String
> name)
> at Microsoft.ReportingServices.Library.RSService.get_MyReportsEnabled()
> at Microsoft.ReportingServices.Library.RSService.PathToInternal(String
> source)
> at Microsoft.ReportingServices.Diagnostics.CatalogItemContext.SetPath(String
> path, Boolean validate, Boolean convert, Boolean translate)
> at Microsoft.ReportingServices.Diagnostics.CatalogItemContext.SetPath(String
> path)
> at Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPageContent()
> at Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPage()
> -- End of inner exception stack trace --
> a
> ===============================================================================> When I navigate to the http://localhost/ReportServer I get the
> following error message:
> An internal error occurred on the report server. (again not very
> helpful).
> IIS is listening on port 80 (and there are no other apps on the port).
>
> SO... I'm running out of things to try and patience. Is there anyone
> out there who can help me get over this problem? I really need to
> get this installed ASAP and there doesn't seem to be any documentation
> anywhere that explains what is going wrong!!!
> Any help appreciated.
> Glenn
>
development box. The local database is SQL Server 2000 sp3.
At the end of the installation I get an error message indicating that
the 'Setup could not initialize the report server' and that I'll have
to manually initialize the Report Server.
After running rsactive I got the message indicating that the "Report
Server Web Service has not generated a public key".
Looking in the log files is less-than-helpful (hundreds of lines
indicating that some -unknown- file is missing):
===============================================================================
aspnet_wp!library!a4!12/01/2004-10:15:58:: e ERROR: Throwing
Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
An internal error occurred on the report server. See the error log for
more details., ;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
An internal error occurred on the report server. See the error log for
more details. --> System.IO.FileNotFoundException: The system cannot
find the file specified.
at System.Runtime.InteropServices.Marshal.ThrowExceptionForHR(Int32
errorCode, IntPtr errorInfo)
at RSManagedCrypto.RSCrypto.ExportPublicKey()
at Microsoft.ReportingServices.Library.ConnectionManager.GetEncryptionKey()
at Microsoft.ReportingServices.Library.ConnectionManager.ConnectStorage()
at Microsoft.ReportingServices.Library.ConnectionManager.VerifyConnection()
at Microsoft.ReportingServices.Library.ConnectionManager.get_Connection()
at Microsoft.ReportingServices.Library.Storage.get_Connection()
at Microsoft.ReportingServices.Library.Storage.NewStandardSqlCommand(String
storedProcedureName)
at Microsoft.ReportingServices.Library.DBInterface.GetOneConfigurationInfo(String
key)
at Microsoft.ReportingServices.Library.CachedSystemProperties.GetSystemProperty(String
name)
at Microsoft.ReportingServices.Library.CachedSystemProperties.Get(String
name)
at Microsoft.ReportingServices.Library.CachedSystemProperties.GetParameter(String
name)
at Microsoft.ReportingServices.Library.RSService.get_MyReportsEnabled()
at Microsoft.ReportingServices.Library.RSService.PathToInternal(String
source)
at Microsoft.ReportingServices.Diagnostics.CatalogItemContext.SetPath(String
path, Boolean validate, Boolean convert, Boolean translate)
at Microsoft.ReportingServices.Diagnostics.CatalogItemContext.SetPath(String
path)
at Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPageContent()
at Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPage()
-- End of inner exception stack trace --
a
===============================================================================
When I navigate to the http://localhost/ReportServer I get the
following error message:
An internal error occurred on the report server. (again not very
helpful).
IIS is listening on port 80 (and there are no other apps on the port).
SO... I'm running out of things to try and patience. Is there anyone
out there who can help me get over this problem? I really need to
get this installed ASAP and there doesn't seem to be any documentation
anywhere that explains what is going wrong!!!
Any help appreciated.
GlennAfter much trail-and-error and finally a call to Microsoft I was able to
install the SRS and get everything working. I'm posting this in hopes that my
solution will help someone in a similar situation.
Ultimately the problem was solved by:
1) accessing the machine.config file
2) find the user name in the process model section (by default it's set
to 'machine')
3) change this to 'system' (temporarily)
4) using EnterpriseManager open the Keys table of the ReportServer
database (three are probably 2 keys)
5) delete the NON-ZERO key (don't delete the ZERO key)
6) browse to http:/localhost/ReportServer (should no longer produce any
errors!!!)
7) browse to http:/localhost/Reposrts
Hope this helps...
Glenn
"Glenn" wrote:
> I'm trying to install Reporting Services on a new XP Pro SP2 IIS 6
> development box. The local database is SQL Server 2000 sp3.
> At the end of the installation I get an error message indicating that
> the 'Setup could not initialize the report server' and that I'll have
> to manually initialize the Report Server.
> After running rsactive I got the message indicating that the "Report
> Server Web Service has not generated a public key".
> Looking in the log files is less-than-helpful (hundreds of lines
> indicating that some -unknown- file is missing):
> ===============================================================================> aspnet_wp!library!a4!12/01/2004-10:15:58:: e ERROR: Throwing
> Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
> An internal error occurred on the report server. See the error log for
> more details., ;
> Info: Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
> An internal error occurred on the report server. See the error log for
> more details. --> System.IO.FileNotFoundException: The system cannot
> find the file specified.
> at System.Runtime.InteropServices.Marshal.ThrowExceptionForHR(Int32
> errorCode, IntPtr errorInfo)
> at RSManagedCrypto.RSCrypto.ExportPublicKey()
> at Microsoft.ReportingServices.Library.ConnectionManager.GetEncryptionKey()
> at Microsoft.ReportingServices.Library.ConnectionManager.ConnectStorage()
> at Microsoft.ReportingServices.Library.ConnectionManager.VerifyConnection()
> at Microsoft.ReportingServices.Library.ConnectionManager.get_Connection()
> at Microsoft.ReportingServices.Library.Storage.get_Connection()
> at Microsoft.ReportingServices.Library.Storage.NewStandardSqlCommand(String
> storedProcedureName)
> at Microsoft.ReportingServices.Library.DBInterface.GetOneConfigurationInfo(String
> key)
> at Microsoft.ReportingServices.Library.CachedSystemProperties.GetSystemProperty(String
> name)
> at Microsoft.ReportingServices.Library.CachedSystemProperties.Get(String
> name)
> at Microsoft.ReportingServices.Library.CachedSystemProperties.GetParameter(String
> name)
> at Microsoft.ReportingServices.Library.RSService.get_MyReportsEnabled()
> at Microsoft.ReportingServices.Library.RSService.PathToInternal(String
> source)
> at Microsoft.ReportingServices.Diagnostics.CatalogItemContext.SetPath(String
> path, Boolean validate, Boolean convert, Boolean translate)
> at Microsoft.ReportingServices.Diagnostics.CatalogItemContext.SetPath(String
> path)
> at Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPageContent()
> at Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPage()
> -- End of inner exception stack trace --
> a
> ===============================================================================> When I navigate to the http://localhost/ReportServer I get the
> following error message:
> An internal error occurred on the report server. (again not very
> helpful).
> IIS is listening on port 80 (and there are no other apps on the port).
>
> SO... I'm running out of things to try and patience. Is there anyone
> out there who can help me get over this problem? I really need to
> get this installed ASAP and there doesn't seem to be any documentation
> anywhere that explains what is going wrong!!!
> Any help appreciated.
> Glenn
>
Problems installing SQLServer 2000 Developer Edition on Windows XP Pro
Hello!
When trying to install SqlServer 2000 Developer (as Administrator) on my
Windows XP Professional I get the following message at the point where
the system asks Local Account or Domain account:
The logon account cannot be validated for the SQL server service. Verify
that the user name and password entered are correct. The logon attempt
failed.
Anyone an idea what goes wrong here?
Thanks for your info.
Daniel
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!Make sure that the account you are providing has the "log on as
service" rights to local machine. After you verified that you didn't
make a typo entering the login. :-)
Alexey
Daniel Kim <daekim_2000@.netzero.net> wrote in message news:<3f73dfb0$0$62084$75868355@.news.frii.net>...
> Hello!
> When trying to install SqlServer 2000 Developer (as Administrator) on my
> Windows XP Professional I get the following message at the point where
> the system asks Local Account or Domain account:
>
> The logon account cannot be validated for the SQL server service. Verify
> that the user name and password entered are correct. The logon attempt
> failed.
>
> Anyone an idea what goes wrong here?
> Thanks for your info.
>
> Daniel
>
> *** Sent via Developersdex http://www.developersdex.com ***
> Don't just participate in USENET...get rewarded for it!sql
Problems installing SQL Server 2000
i have recently formated my laptop, and ever since i can't get SQL Server 2000 running correcly
The install seems to go ok, but when i open Enterprise Manager, and select databases, theres nothing there and i get an error saying the connection has stopped
When i try to install Service Pack 3 i get the following error:
Error running script: sp3_serv_uni.sql(1)
does any 1 know what this means
i've uninstalled many times but i still get the same errors
What am i doing wrong?What OS are you running on your laptop?
What service pack?
What version SQL are you running (Developer? MSDE?)?
You can go to your %SYSTEMROOT% directory and look for sqlstp.log and sqlsp.log. These are the installation log files. Any errors that SQL encounters during install will be documented there. One of the two files increments by 1 each time you attempt the install (but I can't remember which one it is).
The one time that I had trouble installing SQL Server was in a clustered environment, trying to install SQL on a virtual server. It turned out that I had to update the MDAC before trying to install SQL; you may consider updating your MDAC (but that's only a wild guess).
Regards,
hmscott
i have recently formated my laptop, and ever since i can't get SQL Server 2000 running correcly
The install seems to go ok, but when i open Enterprise Manager, and select databases, theres nothing there and i get an error saying the connection has stopped
When i try to install Service Pack 3 i get the following error:
Error running script: sp3_serv_uni.sql(1)
does any 1 know what this means
i've uninstalled many times but i still get the same errors
What am i doing wrong?|||thanks it ok now i've cracked it
The install seems to go ok, but when i open Enterprise Manager, and select databases, theres nothing there and i get an error saying the connection has stopped
When i try to install Service Pack 3 i get the following error:
Error running script: sp3_serv_uni.sql(1)
does any 1 know what this means
i've uninstalled many times but i still get the same errors
What am i doing wrong?What OS are you running on your laptop?
What service pack?
What version SQL are you running (Developer? MSDE?)?
You can go to your %SYSTEMROOT% directory and look for sqlstp.log and sqlsp.log. These are the installation log files. Any errors that SQL encounters during install will be documented there. One of the two files increments by 1 each time you attempt the install (but I can't remember which one it is).
The one time that I had trouble installing SQL Server was in a clustered environment, trying to install SQL on a virtual server. It turned out that I had to update the MDAC before trying to install SQL; you may consider updating your MDAC (but that's only a wild guess).
Regards,
hmscott
i have recently formated my laptop, and ever since i can't get SQL Server 2000 running correcly
The install seems to go ok, but when i open Enterprise Manager, and select databases, theres nothing there and i get an error saying the connection has stopped
When i try to install Service Pack 3 i get the following error:
Error running script: sp3_serv_uni.sql(1)
does any 1 know what this means
i've uninstalled many times but i still get the same errors
What am i doing wrong?|||thanks it ok now i've cracked it
Problems installing SQL Reporting Services
I verified that the prerequisites MDAC, ASP, IIS 5 and MSDTC were all
installed, but I'm getting an error duing the install that says:
"IIS is either not installed or not configured for server component
installation"
Any ideas?
Carlton.
I just solved the same issue. Go to Administrative Tools, IIS Manager and
make sure the Default Web site is not stopped. If it is, then Start it and
then the Reporting Services install will not give you this error.
"Cwhitmore" wrote:
> I verified that the prerequisites MDAC, ASP, IIS 5 and MSDTC were all
> installed, but I'm getting an error duing the install that says:
> "IIS is either not installed or not configured for server component
> installation"
> Any ideas?
> Carlton.
>
|||Sunil,
The default website was running. I have serveral virtual directories that
run fine.
Any other ideas?
Carlton.
"Sunil Gulati" wrote:
[vbcol=seagreen]
> I just solved the same issue. Go to Administrative Tools, IIS Manager and
> make sure the Default Web site is not stopped. If it is, then Start it and
> then the Reporting Services install will not give you this error.
> "Cwhitmore" wrote:
installed, but I'm getting an error duing the install that says:
"IIS is either not installed or not configured for server component
installation"
Any ideas?
Carlton.
I just solved the same issue. Go to Administrative Tools, IIS Manager and
make sure the Default Web site is not stopped. If it is, then Start it and
then the Reporting Services install will not give you this error.
"Cwhitmore" wrote:
> I verified that the prerequisites MDAC, ASP, IIS 5 and MSDTC were all
> installed, but I'm getting an error duing the install that says:
> "IIS is either not installed or not configured for server component
> installation"
> Any ideas?
> Carlton.
>
|||Sunil,
The default website was running. I have serveral virtual directories that
run fine.
Any other ideas?
Carlton.
"Sunil Gulati" wrote:
[vbcol=seagreen]
> I just solved the same issue. Go to Administrative Tools, IIS Manager and
> make sure the Default Web site is not stopped. If it is, then Start it and
> then the Reporting Services install will not give you this error.
> "Cwhitmore" wrote:
Problems installing SQL 2000
I installed VS 2005 which automatically installed SQL 2005. I wanted to also install SQL 2000. I tried to install SQL 2000 (Client tools) after 2005 was installed and there were errors. I then uninstalled SQL 2005 and tried to install SQL 2000 (client tools). This is on my local machine not a server.
I am getting the following error:
"A connection could not be established to XXXX\SQLEXPRESS. Reason: SQL Server does not exist or access denied."
Is there something that I am missing?
Thanks in advance.
That sounds very confusing.
What is instaleld right now on that machine. If you installed SQl Server 2000 in a default instance and SQLExpress, I guess that SQL Express doesn′t have the default port number, so it should be another than the default one 1433. If you use the syntax of Servername\InstanceName,Portnumber you should get the access to the instances without any problem.
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
problems installing security patch of sql server 2000
Hi, in my company the it security departament is demanding to us to
install some patch that avoid some problems with sql server security.
One of this patch is: SQL2000-KB815495-8.00.0818-ENU
When i installed it on all the servers it was fine, but today i try to
install it on a server that has two instansce of sql server. (inst1 and
inst2)
The inst1 get the patch installation but the inst2 doesn´t. When they
scan the server it seems that the patch is not installed because the
inst2 didn´t get it.
Do somebody know how can i install the patch on a second instance'
thanks a lot for your help.
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!When runing the security patch setup, one of the setup windows will prompt
you for what instance to update. You have to run the install for each
instance you wish to update.
Fany Vargas
Microsoft Corporation
This posting is provided "AS IS" with no warranties, and confers no rights.
Are you secure? For information about the Strategic Technology Protection
Program and to order your FREE Security Tool Kit, please visit
http://www.microsoft.com/security.
Microsoft highly recommends that users with Internet access update their
Microsoft software to better protect against viruses and security
vulnerabilities. The easiest way to do this is to visit the following
websites:
http://www.microsoft.com/protect
http://www.microsoft.com/security/guidance/default.mspxsql
install some patch that avoid some problems with sql server security.
One of this patch is: SQL2000-KB815495-8.00.0818-ENU
When i installed it on all the servers it was fine, but today i try to
install it on a server that has two instansce of sql server. (inst1 and
inst2)
The inst1 get the patch installation but the inst2 doesn´t. When they
scan the server it seems that the patch is not installed because the
inst2 didn´t get it.
Do somebody know how can i install the patch on a second instance'
thanks a lot for your help.
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!When runing the security patch setup, one of the setup windows will prompt
you for what instance to update. You have to run the install for each
instance you wish to update.
Fany Vargas
Microsoft Corporation
This posting is provided "AS IS" with no warranties, and confers no rights.
Are you secure? For information about the Strategic Technology Protection
Program and to order your FREE Security Tool Kit, please visit
http://www.microsoft.com/security.
Microsoft highly recommends that users with Internet access update their
Microsoft software to better protect against viruses and security
vulnerabilities. The easiest way to do this is to visit the following
websites:
http://www.microsoft.com/protect
http://www.microsoft.com/security/guidance/default.mspxsql
Problems Installing Reporting Services on Win2003
Hello All,
I have been trying to install reporting svcs EE on win2003 server for
the past 4 days. but not successful so far.
This is the set up i have.
win 2003, sql server 2000 EE and reporting svcs EE.
trying to create the RS databases on the local SQL server.
First I tried using the
1. Select NT Authority\SYSTEM account
2. default names for the virtual dirs
3. local sql server instance and a Service Account.
Here it says i need this hot fix QFE 859 but couldnt find it on the MS
site.
Second Attempt
1. Select NT Authority\SYSTEM account
2. default names for the virtual dirs
3. local sql server instance and a SQL login account.
It completes most of the installation but throws up this error saying
cant connect to the databases.
I see the local sql server and see that the RS databases are created
I try to access the http://<server>/Report and ReportManager
I give the user/passwd, its authenticated and in the end I get a
message saying couldnt not connect to the database.
I would like to know if anyone faced similar issues and if there is way
around this.
Thanks
BofoThe NT Authority\SYSTEM account uses the Bultin\Administrator account to
login tin SQL. If this account is missing you would see this error. If the
account it there make sure it has access to the databases. For use, we used a
Domain User account for the install of RS and SQL.
"Win2003InstallIssues" wrote:
> Hello All,
> I have been trying to install reporting svcs EE on win2003 server for
> the past 4 days. but not successful so far.
> This is the set up i have.
> win 2003, sql server 2000 EE and reporting svcs EE.
> trying to create the RS databases on the local SQL server.
> First I tried using the
> 1. Select NT Authority\SYSTEM account
> 2. default names for the virtual dirs
> 3. local sql server instance and a Service Account.
> Here it says i need this hot fix QFE 859 but couldnt find it on the MS
> site.
> Second Attempt
> 1. Select NT Authority\SYSTEM account
> 2. default names for the virtual dirs
> 3. local sql server instance and a SQL login account.
> It completes most of the installation but throws up this error saying
> cant connect to the databases.
> I see the local sql server and see that the RS databases are created
> I try to access the http://<server>/Report and ReportManager
> I give the user/passwd, its authenticated and in the end I get a
> message saying couldnt not connect to the database.
> I would like to know if anyone faced similar issues and if there is way
> around this.
> Thanks
> Bofo
>|||Thanks for the info. That was probably the problem. I used the NT
Authority\NETWORK SERVICE account and used a domain user account for
the ReportServer and seems to do fine.
at the end of the installation a couple of DOS windows pop-up
the first one says
"cannot connect to the database as the name of the server already
exists or a duplicate go to system utilities and change the name....
or something like that.
But the Reports and ReportServer urls seems to do fine.
Is this due to the fact that I have the SQL server and the RS running
from the same physical machine ?
Also would like to know what is the best way to setup the system. Like
having the SQL server on a seperate machine or it doesnt really matter.
Thanks
Bofo|||The RS databases have to be on SQL, whether or not ReportServer and Report
Manager are on the same machine does not matter.That is the good thing about
EE RS. You have flexibility in how you want to deploy your solutions. As an
example, we currently have RS, the RS databases and IIS on one server that
access another SQL Server for the reports. We will be moving to an App Center
load balanced IIS cluster, RS and databases in the middle and then the
external SQL Server for the data. This will give us the flexibility we need.
"Win2003InstallIssues" wrote:
> Thanks for the info. That was probably the problem. I used the NT
> Authority\NETWORK SERVICE account and used a domain user account for
> the ReportServer and seems to do fine.
> at the end of the installation a couple of DOS windows pop-up
> the first one says
> "cannot connect to the database as the name of the server already
> exists or a duplicate go to system utilities and change the name....
> or something like that.
> But the Reports and ReportServer urls seems to do fine.
> Is this due to the fact that I have the SQL server and the RS running
> from the same physical machine ?
> Also would like to know what is the best way to setup the system. Like
> having the SQL server on a seperate machine or it doesnt really matter.
> Thanks
> Bofo
>|||Hi, Thanks very much for the info.
I was able to install it successfully when I had the SQL server running
locally.
But I need to make to work having the SQL server on a different
machine.
Here is my scenario.
1. SQL server 2000 is running on a Win2003 Server which is NOT in my
domain and I want my RS databases on this machine.
2. Reporting services, IIS will run on my machine which is also running
Win2003 Server
My options during installation are
Windows Authenication and
for the reportServer a Service account (default) option
At the end of the installation I get a message saying that Reporting
Services cannot be initalized
I try to access the localhost/Reports
and 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 '(null)'. Reason: Not associated with a trusted SQL
Server connection.
=============
I would like to know if the problem is due to the fact that the SQL
server is running outside my domain ?
Also I would appreciate what are the best options to choose for the
account types, I read diff docs and each give a different opinion. I am
very new to this type of environment and feeling stupid for not being
able to make this work.
Thanks
Bofo|||Sorry it took so long to get back to you. To answer your questions.
Is there a trust relation between the two domains? This will be need to
ensure that authenication will work.
I would recommend that you setup IIS and RS to run under the account of a
Domain User with local admin on the servers. Then have the user IIS and RS
service is running under be set as trusted for delegation as well as the
servers. If you still get the "Login failed for user '(null)' error then we
need to make sure that the kerberos ticket is being passed. If it is not
being passed then you will have to manually create SPN entries for these
users and servers to ensure that the kerberos ticket is passed and received.
I do not know of any problems with the way you have it designed. Remember,
the more comlex the install the harder it is to troubleshoot.
"Win2003InstallIssues" wrote:
> Hi, Thanks very much for the info.
> I was able to install it successfully when I had the SQL server running
> locally.
> But I need to make to work having the SQL server on a different
> machine.
> Here is my scenario.
> 1. SQL server 2000 is running on a Win2003 Server which is NOT in my
> domain and I want my RS databases on this machine.
> 2. Reporting services, IIS will run on my machine which is also running
> Win2003 Server
> My options during installation are
> Windows Authenication and
> for the reportServer a Service account (default) option
> At the end of the installation I get a message saying that Reporting
> Services cannot be initalized
> I try to access the localhost/Reports
> and 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 '(null)'. Reason: Not associated with a trusted SQL
> Server connection.
> =============> I would like to know if the problem is due to the fact that the SQL
> server is running outside my domain ?
> Also I would appreciate what are the best options to choose for the
> account types, I read diff docs and each give a different opinion. I am
> very new to this type of environment and feeling stupid for not being
> able to make this work.
> Thanks
> Bofo
>|||Hey !
thanks for the all the info. I got it going. the problem was that i
created the domain after SQL server was installed and also my co-worker
was using Windows Auth Only. So the problem with trusted connection.
Changed the option to Windows and SQL accounts and created a sql acc
with admin permissions and viola !
but i am stuck with SQL query issues now (I have already posted my
problem under another thread)
http://groups-beta.google.com/group/microsoft.public.sqlserver.reportingsvcs/browse_thread/thread/b0fb9b6091537e6f/1ac3d86d514559be
thanks
bofo
I have been trying to install reporting svcs EE on win2003 server for
the past 4 days. but not successful so far.
This is the set up i have.
win 2003, sql server 2000 EE and reporting svcs EE.
trying to create the RS databases on the local SQL server.
First I tried using the
1. Select NT Authority\SYSTEM account
2. default names for the virtual dirs
3. local sql server instance and a Service Account.
Here it says i need this hot fix QFE 859 but couldnt find it on the MS
site.
Second Attempt
1. Select NT Authority\SYSTEM account
2. default names for the virtual dirs
3. local sql server instance and a SQL login account.
It completes most of the installation but throws up this error saying
cant connect to the databases.
I see the local sql server and see that the RS databases are created
I try to access the http://<server>/Report and ReportManager
I give the user/passwd, its authenticated and in the end I get a
message saying couldnt not connect to the database.
I would like to know if anyone faced similar issues and if there is way
around this.
Thanks
BofoThe NT Authority\SYSTEM account uses the Bultin\Administrator account to
login tin SQL. If this account is missing you would see this error. If the
account it there make sure it has access to the databases. For use, we used a
Domain User account for the install of RS and SQL.
"Win2003InstallIssues" wrote:
> Hello All,
> I have been trying to install reporting svcs EE on win2003 server for
> the past 4 days. but not successful so far.
> This is the set up i have.
> win 2003, sql server 2000 EE and reporting svcs EE.
> trying to create the RS databases on the local SQL server.
> First I tried using the
> 1. Select NT Authority\SYSTEM account
> 2. default names for the virtual dirs
> 3. local sql server instance and a Service Account.
> Here it says i need this hot fix QFE 859 but couldnt find it on the MS
> site.
> Second Attempt
> 1. Select NT Authority\SYSTEM account
> 2. default names for the virtual dirs
> 3. local sql server instance and a SQL login account.
> It completes most of the installation but throws up this error saying
> cant connect to the databases.
> I see the local sql server and see that the RS databases are created
> I try to access the http://<server>/Report and ReportManager
> I give the user/passwd, its authenticated and in the end I get a
> message saying couldnt not connect to the database.
> I would like to know if anyone faced similar issues and if there is way
> around this.
> Thanks
> Bofo
>|||Thanks for the info. That was probably the problem. I used the NT
Authority\NETWORK SERVICE account and used a domain user account for
the ReportServer and seems to do fine.
at the end of the installation a couple of DOS windows pop-up
the first one says
"cannot connect to the database as the name of the server already
exists or a duplicate go to system utilities and change the name....
or something like that.
But the Reports and ReportServer urls seems to do fine.
Is this due to the fact that I have the SQL server and the RS running
from the same physical machine ?
Also would like to know what is the best way to setup the system. Like
having the SQL server on a seperate machine or it doesnt really matter.
Thanks
Bofo|||The RS databases have to be on SQL, whether or not ReportServer and Report
Manager are on the same machine does not matter.That is the good thing about
EE RS. You have flexibility in how you want to deploy your solutions. As an
example, we currently have RS, the RS databases and IIS on one server that
access another SQL Server for the reports. We will be moving to an App Center
load balanced IIS cluster, RS and databases in the middle and then the
external SQL Server for the data. This will give us the flexibility we need.
"Win2003InstallIssues" wrote:
> Thanks for the info. That was probably the problem. I used the NT
> Authority\NETWORK SERVICE account and used a domain user account for
> the ReportServer and seems to do fine.
> at the end of the installation a couple of DOS windows pop-up
> the first one says
> "cannot connect to the database as the name of the server already
> exists or a duplicate go to system utilities and change the name....
> or something like that.
> But the Reports and ReportServer urls seems to do fine.
> Is this due to the fact that I have the SQL server and the RS running
> from the same physical machine ?
> Also would like to know what is the best way to setup the system. Like
> having the SQL server on a seperate machine or it doesnt really matter.
> Thanks
> Bofo
>|||Hi, Thanks very much for the info.
I was able to install it successfully when I had the SQL server running
locally.
But I need to make to work having the SQL server on a different
machine.
Here is my scenario.
1. SQL server 2000 is running on a Win2003 Server which is NOT in my
domain and I want my RS databases on this machine.
2. Reporting services, IIS will run on my machine which is also running
Win2003 Server
My options during installation are
Windows Authenication and
for the reportServer a Service account (default) option
At the end of the installation I get a message saying that Reporting
Services cannot be initalized
I try to access the localhost/Reports
and 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 '(null)'. Reason: Not associated with a trusted SQL
Server connection.
=============
I would like to know if the problem is due to the fact that the SQL
server is running outside my domain ?
Also I would appreciate what are the best options to choose for the
account types, I read diff docs and each give a different opinion. I am
very new to this type of environment and feeling stupid for not being
able to make this work.
Thanks
Bofo|||Sorry it took so long to get back to you. To answer your questions.
Is there a trust relation between the two domains? This will be need to
ensure that authenication will work.
I would recommend that you setup IIS and RS to run under the account of a
Domain User with local admin on the servers. Then have the user IIS and RS
service is running under be set as trusted for delegation as well as the
servers. If you still get the "Login failed for user '(null)' error then we
need to make sure that the kerberos ticket is being passed. If it is not
being passed then you will have to manually create SPN entries for these
users and servers to ensure that the kerberos ticket is passed and received.
I do not know of any problems with the way you have it designed. Remember,
the more comlex the install the harder it is to troubleshoot.
"Win2003InstallIssues" wrote:
> Hi, Thanks very much for the info.
> I was able to install it successfully when I had the SQL server running
> locally.
> But I need to make to work having the SQL server on a different
> machine.
> Here is my scenario.
> 1. SQL server 2000 is running on a Win2003 Server which is NOT in my
> domain and I want my RS databases on this machine.
> 2. Reporting services, IIS will run on my machine which is also running
> Win2003 Server
> My options during installation are
> Windows Authenication and
> for the reportServer a Service account (default) option
> At the end of the installation I get a message saying that Reporting
> Services cannot be initalized
> I try to access the localhost/Reports
> and 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 '(null)'. Reason: Not associated with a trusted SQL
> Server connection.
> =============> I would like to know if the problem is due to the fact that the SQL
> server is running outside my domain ?
> Also I would appreciate what are the best options to choose for the
> account types, I read diff docs and each give a different opinion. I am
> very new to this type of environment and feeling stupid for not being
> able to make this work.
> Thanks
> Bofo
>|||Hey !
thanks for the all the info. I got it going. the problem was that i
created the domain after SQL server was installed and also my co-worker
was using Windows Auth Only. So the problem with trusted connection.
Changed the option to Windows and SQL accounts and created a sql acc
with admin permissions and viola !
but i am stuck with SQL query issues now (I have already posted my
problem under another thread)
http://groups-beta.google.com/group/microsoft.public.sqlserver.reportingsvcs/browse_thread/thread/b0fb9b6091537e6f/1ac3d86d514559be
thanks
bofo
Problems installing msde2000a
When i try to install MSDE2000A i get the following error message:
The system cannot open the device or file specified.
Internal error 2755. 110
C:\Msde\Setup\SqlRun01.msi
I start with the following parametres:
DISABLENETWORKPROTOCOLS=0 INSTANCENAME="OpfServer" SAPWD="Opf" SECURITYMODE=SQL
Regards,
Olav
Maybe the media you are installing from is corrupt or the file is missing?
Jim
"Olav" <anonymous@.discussions.microsoft.com> wrote in message
news:BC928DD0-41AC-444E-B211-3A4E7F5800FD@.microsoft.com...
> When i try to install MSDE2000A i get the following error message:
> The system cannot open the device or file specified.
> Internal error 2755. 110
> C:\Msde\Setup\SqlRun01.msi
> I start with the following parametres:
> DISABLENETWORKPROTOCOLS=0 INSTANCENAME="OpfServer" SAPWD="Opf"
SECURITYMODE=SQL
> Regards,
> Olav
|||Hi Jim,
I have just downloaded it from MS and unwrapped it to my harddsisk with the message that it was succesfully delivered. The file SqlRun01.msi is in the Setup directory.
I have uninstalled MS SQL Server 2000 and rebooted after.
Regards,
Olav
The system cannot open the device or file specified.
Internal error 2755. 110
C:\Msde\Setup\SqlRun01.msi
I start with the following parametres:
DISABLENETWORKPROTOCOLS=0 INSTANCENAME="OpfServer" SAPWD="Opf" SECURITYMODE=SQL
Regards,
Olav
Maybe the media you are installing from is corrupt or the file is missing?
Jim
"Olav" <anonymous@.discussions.microsoft.com> wrote in message
news:BC928DD0-41AC-444E-B211-3A4E7F5800FD@.microsoft.com...
> When i try to install MSDE2000A i get the following error message:
> The system cannot open the device or file specified.
> Internal error 2755. 110
> C:\Msde\Setup\SqlRun01.msi
> I start with the following parametres:
> DISABLENETWORKPROTOCOLS=0 INSTANCENAME="OpfServer" SAPWD="Opf"
SECURITYMODE=SQL
> Regards,
> Olav
|||Hi Jim,
I have just downloaded it from MS and unwrapped it to my harddsisk with the message that it was succesfully delivered. The file SqlRun01.msi is in the Setup directory.
I have uninstalled MS SQL Server 2000 and rebooted after.
Regards,
Olav
Problems installing MSDE Desktop SP3a SQL server
Hi,
I'm trying to install MSDE Desktop SP3a SQL server on my Windows 2000 Professional Laptop.
Every time I try it nearly finishes the installation and then just rollsback.
Can anyone help? Is this a known issue?
Thanks in advance,
JockyHave you tried using the verbose logging switch when you install? You need to add something like this to the setup.exe you are running fromthe commandline:
|||The following article might help you setup MSDE from command line.
http://support.microsoft.com/default.aspx?scid=KB;EN-US;Q324998|||
I'm trying to install MSDE Desktop SP3a SQL server on my Windows 2000 Professional Laptop.
Every time I try it nearly finishes the installation and then just rollsback.
Can anyone help? Is this a known issue?
Thanks in advance,
JockyHave you tried using the verbose logging switch when you install? You need to add something like this to the setup.exe you are running fromthe commandline:
/L*v c:\msde_install.log
|||The following article might help you setup MSDE from command line.
http://support.microsoft.com/default.aspx?scid=KB;EN-US;Q324998|||
That Microsoft article did the trick. Thanks y'all!
Jocky.
Problems Installing MSDE 2000
Hi,
I trying to install MSDE 2000 in my PC a lot of times, but unsucessfully;
show me a pop-up screen:Setup failed to configure the server. Refer to the
server error logs and setup error logs for more information.
My log file:
2005-05-07 10:01:25.98 server Microsoft SQL Server 2000 - 8.00.760 (Intel
X86)
Dec 17 2002 14:22:05
Copyright (c) 1988-2003 Microsoft Corporation
Desktop Engine on Windows NT 5.1 (Build 2600: Service Pack 1)
2005-05-07 10:01:25.98 server Copyright (C) 1988-2002 Microsoft
Corporation.
2005-05-07 10:01:25.98 server All rights reserved.
2005-05-07 10:01:25.98 server Server Process ID is 3264.
2005-05-07 10:01:25.98 server Logging SQL Server messages in file
'C:\Program Files\Microsoft SQL Server\MSSQL\Data\MSSQL\LOG\ERRORLOG'.
2005-05-07 10:01:26.00 server SQL Server is starting at priority class
'normal'(1 CPU detected).
2005-05-07 10:01:26.01 server SQL Server configured for thread mode
processing.
2005-05-07 10:01:26.01 server Using dynamic lock allocation. [500] Lock
Blocks, [1000] Lock Owner Blocks.
2005-05-07 10:01:26.03 spid3 Warning ******************
2005-05-07 10:01:26.03 spid3 SQL Server started in single user mode.
Updates allowed to system catalogs.
2005-05-07 10:01:26.03 spid3 Starting up database 'master'.
2005-05-07 10:01:26.57 server Using 'SSNETLIB.DLL' version '8.0.766'.
2005-05-07 10:01:26.57 spid5 Starting up database 'model'.
2005-05-07 10:01:26.64 spid3 Server name is 'KL55692'.
2005-05-07 10:01:26.64 spid3 Skipping startup of clean database id 5
2005-05-07 10:01:26.64 spid3 Skipping startup of clean database id 6
2005-05-07 10:01:26.64 spid3 Starting up database 'msdb'.
2005-05-07 10:01:26.79 server SQL server listening on Shared Memory.
2005-05-07 10:01:26.79 server SQL Server is ready for client connections
2005-05-07 10:01:27.40 spid5 Clearing tempdb database.
2005-05-07 10:01:28.00 spid5 Starting up database 'tempdb'.
2005-05-07 10:01:28.07 spid3 Recovery complete.
2005-05-07 10:01:28.07 spid3 SQL global counter collection task is
created.
2005-05-07 10:01:28.17 spid3 Warning: override, autoexec procedures
skipped.
2005-05-07 10:01:36.51 spid3 SQL Server is terminating due to 'stop'
request from Service Control Manager.
In my event viewer/ Application:
Type: Error Source: MsiInstaller Event: 1013
and my setup.ini file:
[Options]
DATADIR=C:\Program Files\Microsoft SQL Server\MSSQL\Data\
DISABLENETWORKPROTOCOLS=1
SAPWD=sa
SECURITYMODE=SQL
TARGETDIR=C:\Program Files\Microsoft SQL Server\MSSQL\Binn\
Do you have any idea how fix this?
hi Ivan,
Ivan Anzaldua wrote:
> Hi,
> I trying to install MSDE 2000 in my PC a lot of times, but
> unsucessfully; show me a pop-up screen:Setup failed to configure the
> server. Refer to the server error logs and setup error logs for more
> information.
this error usually shows up when a previously disinstalled MSDE instance has
not been properly cleaned up... please refer to
http://support.microsoft.com/default...99&Product=sql
for further info
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.11.1 - DbaMgr ver 0.57.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
I trying to install MSDE 2000 in my PC a lot of times, but unsucessfully;
show me a pop-up screen:Setup failed to configure the server. Refer to the
server error logs and setup error logs for more information.
My log file:
2005-05-07 10:01:25.98 server Microsoft SQL Server 2000 - 8.00.760 (Intel
X86)
Dec 17 2002 14:22:05
Copyright (c) 1988-2003 Microsoft Corporation
Desktop Engine on Windows NT 5.1 (Build 2600: Service Pack 1)
2005-05-07 10:01:25.98 server Copyright (C) 1988-2002 Microsoft
Corporation.
2005-05-07 10:01:25.98 server All rights reserved.
2005-05-07 10:01:25.98 server Server Process ID is 3264.
2005-05-07 10:01:25.98 server Logging SQL Server messages in file
'C:\Program Files\Microsoft SQL Server\MSSQL\Data\MSSQL\LOG\ERRORLOG'.
2005-05-07 10:01:26.00 server SQL Server is starting at priority class
'normal'(1 CPU detected).
2005-05-07 10:01:26.01 server SQL Server configured for thread mode
processing.
2005-05-07 10:01:26.01 server Using dynamic lock allocation. [500] Lock
Blocks, [1000] Lock Owner Blocks.
2005-05-07 10:01:26.03 spid3 Warning ******************
2005-05-07 10:01:26.03 spid3 SQL Server started in single user mode.
Updates allowed to system catalogs.
2005-05-07 10:01:26.03 spid3 Starting up database 'master'.
2005-05-07 10:01:26.57 server Using 'SSNETLIB.DLL' version '8.0.766'.
2005-05-07 10:01:26.57 spid5 Starting up database 'model'.
2005-05-07 10:01:26.64 spid3 Server name is 'KL55692'.
2005-05-07 10:01:26.64 spid3 Skipping startup of clean database id 5
2005-05-07 10:01:26.64 spid3 Skipping startup of clean database id 6
2005-05-07 10:01:26.64 spid3 Starting up database 'msdb'.
2005-05-07 10:01:26.79 server SQL server listening on Shared Memory.
2005-05-07 10:01:26.79 server SQL Server is ready for client connections
2005-05-07 10:01:27.40 spid5 Clearing tempdb database.
2005-05-07 10:01:28.00 spid5 Starting up database 'tempdb'.
2005-05-07 10:01:28.07 spid3 Recovery complete.
2005-05-07 10:01:28.07 spid3 SQL global counter collection task is
created.
2005-05-07 10:01:28.17 spid3 Warning: override, autoexec procedures
skipped.
2005-05-07 10:01:36.51 spid3 SQL Server is terminating due to 'stop'
request from Service Control Manager.
In my event viewer/ Application:
Type: Error Source: MsiInstaller Event: 1013
and my setup.ini file:
[Options]
DATADIR=C:\Program Files\Microsoft SQL Server\MSSQL\Data\
DISABLENETWORKPROTOCOLS=1
SAPWD=sa
SECURITYMODE=SQL
TARGETDIR=C:\Program Files\Microsoft SQL Server\MSSQL\Binn\
Do you have any idea how fix this?
hi Ivan,
Ivan Anzaldua wrote:
> Hi,
> I trying to install MSDE 2000 in my PC a lot of times, but
> unsucessfully; show me a pop-up screen:Setup failed to configure the
> server. Refer to the server error logs and setup error logs for more
> information.
this error usually shows up when a previously disinstalled MSDE instance has
not been properly cleaned up... please refer to
http://support.microsoft.com/default...99&Product=sql
for further info
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.11.1 - DbaMgr ver 0.57.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
Problems installing MSDE
I was in the process of installing the MSDE program when I came upon an error message. Here are the steps I performed to install the MSDE on my computer.
1. Downloaded the program from the Microsoft website.
2. Extracted the files to the "C" directory.
3. Used command prompt to set password and security mode. Rebooted computer after process was completed.
4. To complete the installation, I opened up the setup.exe. However, I got the error message "The instance named specified is invalid" when I opened the program.
Any solutions? (and yes, I already have the Web Matrix and the .Net platorm and am running on Windows 2000 SP4 .)I just finished dealing with this problem myself.
This is what I did and it FINALLY WORKED.
To install the MSDE:
go to the DOS prompt and navigate to C:\sql2ksp3\MSDE (or wherever you unpacked to).
Type this: setup INSTANCENAME="anyname" SECURITYMODE=SQL SAPWD="somepwd"
If you are like me you were thinking "what is the instance name?!". Well in this setup command you are naming it whatever you want, same with the SAPWD. Previously mine was blank (I know this is bad bad bad).
Anyway, once I ran it this way it installed fine!
Good Luck|||Well this may sound really stupid, but I;m a real newbie...
I've read dozens of setup instruction posts..I've started over and done what was suggested in this post, and everything seems to have gone well. SO FAR
Where do I go from here? Do I have to activate the database somehow? Where is this database anyway, after the I run the command, what was installed and where?
The startkit 'congifuration' still fails everytime. Says I don't have either .NET, MSDE, or IIS. I KNOW I have all of this installed..the only weak link could be the MSDE, because I have no idea what is going on with it.
I've installed SQL Server2000 in the past and got to a point where it configured and coulnd fidn the database..
Anyway, are there STEP BY STEP instructions ANYWHERE on this crap. I'm getting sick of reading random posts, web documentation, program documentation, and trying to compile this in to a process to follow..|||As Cheyjey mentioned, use this parameters:
INSTANCENAME="anyname" SECURITYMODE=SQL SAPWD="somepwd"
But you said installed it once, i have to mention that one the major reasons for getting the error you said, is that you have already installed MSDE on your system...|||i mean MSDE SP3a|||And Dear Mickey,
it's not as hard as you say, MSDE is a kind of a server, you can use it either as a server and an interface between applications and SQL Server 2000|||Amins2s,
I've read many post regarding the installation of MSDE, and i'm having the same problems.
I'm new at this and have followed instructions, and am using MSDE for school project.
I have installed VS 2002 Enterprise Architect, then uninstalled it to upgrade to VS 2003
I download the MSDE SP3a service pack from MS, and try to install it.
I'm suppose to use SAPWD=itm and SECURITYMODE=SQL, but upon typing this, i get the speciefed instance is invalid.
How am i suppose to recitfy this. How do i know what the instance i have on it is?
Also you said that you might be getting this error because you have already installed it once before. But i don't remember installing it, since the only thing i have installed is the VS2002 and VS2003, plus the Framework.
If you've installed it once before, how can you correct it so that you can properly install it now?
Even when i go to the MS .net/Frameworksdk/samples/setup/ there is no msde file to execute, which i read from other post should be there.
Thank You.
Nick|||Hello dear Nick,
ok... give this solution a try: do not indicate the SECURITYMODE parameter. Just run it from the Start>Run and use the SAPWD=itm parameter only!
And from the point that my FrameworkSDK doesn't work (the CD is corrupted), unfotunately I can't answer the question.
Please try it and tell me if it worked or not.
If it didn't, then send a feedback (Reply) and this time with more details about your system info...
Problems installing Client tools and BOL
I have tried several times to install SQL Server 2005 Enterprise Edition on a cluster. SQL Server, SQL browser and SQL Agent installs ok but when the installer start to setup Books on line and client tools (BIDS) and SS Management Studio the installer stops and end the installation.
I get this error (from SQLSetup0021_WBOGSQL01_Core(Local).log)
Remote setup(s) are ready
Notify package to begin: 29539
Notify package to commit: 29539
Waiting for remote setup(s) to get ready to end
Remote setup(s) are ready
Notify package to end: 29539
Error: Action "UninstallForRS2000Action" failed during execution. Error information reported during run:
Action: "UninstallForRS2000Action" will be marked as failed due to the following condition:
Condition "rs was successfully upgraded." returned false.
Installation of package: "patchRS2000" failed due to a precondition.
Waiting for actions from remote setup(s)
Remote setup(s) are ready
Notify package action is determined: 0
Running: InstallToolsAction.10 at: 2006/6/23 2:3:42
Error: Action "InstallToolsAction.10" threw an exception during execution. Error information reported during run:
Target collection includes the local machine.
Fatal Exception caught while installing package: "10"
Error Code: 0x80070002 (2)
Windows Error Text: The system cannot find the file specified.
Source File Name: sqlchaining\sqlprereqpackagemutator.cpp
Compiler Timestamp: Tue Aug 9 01:14:20 2005
Function Name: sqls::SqlPreReqPackageMutator::modifyRequest
Source Line Number: 196
- Context --
sqls::InstallPackageAction::perform
sqls::InstallPackageAction::getReferringPackageId
ch::installA
WinException caught while installing package. : 1603
Error Code: 0x80070643 (1603)
Windows Error Text: Fatal error during installation.
Source File Name: packageengine\installpackageaction.cpp
Compiler Timestamp: Fri Jul 1 01:28:25 2005
Function Name: sqls::InstallPackageAction::perform
Source Line Number: 167
- Context --
sqls::InstallPackageAction::perform
sqls::InstallPackageAction::getReferringPackageId
ch::installA
Cancelling setup due to failure on remote machine: 1603
Error: Failed to add file :"C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0021_WBOGSQL01_.NET Framework 2.0.log" to cab file : "C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\SqlSetup0021.cab" Error Code : 2
Error: Failed to add file :"C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0021_WBOGSQL01_.NET Framework 2.0 LangPack.log" to cab file : "C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\SqlSetup0021.cab" Error Code : 2
Error: Failed to add file :"C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0021_WBOGSQL01_.NET Framework Upgrade Advisor.log" to cab file : "C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\SqlSetup0021.cab" Error Code : 2
Error: Failed to add file :"C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0021_WBOGSQL01_.NET Framework Upgrade Advisor LangPack.log" to cab file : "C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\SqlSetup0021.cab" Error Code : 2
Error: Failed to add file :"C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0021_WBOGSQL01_.NET Framework Windows Installer.log" to cab file : "C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\SqlSetup0021.cab" Error Code : 2
Error: Failed to add file :"C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0021_WBOGSQL01_.NET Framework Windows Installer LangPack.log" to cab file : "C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\SqlSetup0021.cab" Error Code : 2
Running: UploadDrWatsonLogAction at: 2006/6/23 2:6:2
Message pump returning: 1603
Why does the installation process stop there and what can I do next?
Best regards
Andres
See this article but it hasn't solved the problem for me.
http://support.microsoft.com/?kbid=916760
Problems instaling IIS & Notification Service
I am trying to install SQL server 2005 Developer Edition on a stand alone PC running XP (service pack 2). I have the below error messages preventing me installing Notification Services and Intergration Services ( looks like the same problem for both ). I followed the advice to check the 'Distributed TransactionCoordinator' in services, all setting were correct. I stopped amd restarted the service and selected "retry' to no avail. Any ideas anyone?
Messages:
TITLE: Microsoft SQL Server 2005 Setup
Failed to install and configure assemblies C:\Program Files\Microsoft SQL Server\90\DTS\Tasks\Microsoft.SqlServer.MSMQTask.dll in the COM+ catalog. Error: -2147024894
Error message: The system cannot find the file specified.
Error description: Could not load file or assembly 'System.EnterpriseServices, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' or one of its dependencies. The system cannot find the file specified.
For help, click: http://go.microsoft.com/fwlink?LinkID=20476&ProdName=Microsoft+SQL+Server&ProdVer=9.00.1399.06&EvtSrc=setup.rll&EvtID=29549&EvtType=sqlca%5csqlassembly.cpp%40Do_sqlAssemblyRegSvcs%40Do_sqlAssemblyRegSvcs%40x80070002
BUTTONS:
&Abort
&Retry
&Ignore
TITLE: Microsoft SQL Server 2005 Setup
Failed to install and configure assemblies C:\Program Files\Microsoft SQL Server\90\NotificationServices\9.0.242\Bin\microsoft.sqlserver.notificationservices.dll in the COM+ catalog. Error: -2147024894
Error message: The system cannot find the file specified.
Error description: Could not load file or assembly 'System.EnterpriseServices, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' or one of its dependencies. The system cannot find the file specified.
For help, click: http://go.microsoft.com/fwlink?LinkID=20476&ProdName=Microsoft+SQL+Server&ProdVer=9.00.1399.06&EvtSrc=setup.rll&EvtID=29549&EvtType=sqlca%5csqlassembly.cpp%40Do_sqlAssemblyRegSvcs%40Do_sqlAssemblyRegSvcs%40x80070002
BUTTONS:
&Abort
&Retry
&Ignore
Thanks in advance
ADG
can you try to reinstall .NET Framework 2.0 and then try the setup again?
You can find x86 vesrion of .NET 2.0 redistributable at: http://www.microsoft.com/downloads/details.aspx?FamilyID=0856EACB-4362-4B0D-8EDD-AAB15C5E04F5&displaylang=en
The page also contains links to x64 and ia64 versions at the bottom.
|||Many thanks Jin
I downloaded .net 2.0 as suggested, and selected repair. Service loaded fine afterwards
Wednesday, March 28, 2012
Problems Initializing Reporting Serivices
We are trying to install Reporting Services on a server and we are getting
this error.
ReportServicesConfigUI.WMIProvider.WMIProviderException: The version does
not match a supported version.
at
ReportServicesConfigUI.WMIProvider.RSReportServerAdmin.GenerateDatabaseUpgradeScript(String databaseName, String serverVersion, String& script)
just to be sure, it that mean the version of SQL Server we have will not
allow Reporting services to be installed or is it something else that cause
the error?
We have SQL Server Enterprise 64x.On Dec 13, 9:02 am, Ben <B...@.discussions.microsoft.com> wrote:
> We are trying to install Reporting Services on a server and we are getting
> this error.
> ReportServicesConfigUI.WMIProvider.WMIProviderException: The version does
> not match a supported version.
> at
> ReportServicesConfigUI.WMIProvider.RSReportServerAdmin.GenerateDatabaseUpgradeScript(String databaseName, String serverVersion, String& script)
> just to be sure, it that mean the version of SQL Server we have will not
> allow Reporting services to be installed or is it something else that cause
> the error?
> We have SQL Server Enterprise 64x.
It seems like your SQL Server version is different than your SSRS
version. This link might help. http://207.46.236.188/MSDN/ShowPost.aspx?PostID=2294611&SiteID=1
Regards,
Enrique Martinez
Sr. Software Consultant|||Are you trying to do a fresh install of Reporting Services or are you just
now trying to configure it?
If you are trying to configure it make sure that when you installed SRS
from the SQL Server 2005 media that you re-applied any service packs that
you put on SQL Server 2005 before installing Reporting Services. This can
happen when the current installation is at an SP1 or SP2 level yet the
installed files from SRS are at an RTM level.
If it is a "Fresh" install of SRS see if you can select the radio button
that says "Configure Later" rather than the "Common Configuration" button.
This will allow you to do all of the configuration steps after SRS has
installed. This will allow you to apply any SPs necessary before you try
and configure SRS.
Also, if you are trying to upgrade an instance of SQL Server 2000 SRS you
can always upgrade the database AFTER you have installed 2005 SRS. You
don't have to upgrade the existing instance of SRS all you actually need is
the database. Just make sure you exported the encryption key for the
database from the old SRS 2000 instance before doing that. (You can do this
by using the rskeymgmt tool in the 80\tools\binn folder. Just do a
rskeymgmt -? and look for the key export example)
--
Chris Alton, Microsoft Corp.
SQL Server Developer Support Engineer
This posting is provided "AS IS" with no warranties, and confers no rights.
--
> Thread-Topic: Problems Initializing Reporting Serivices
>
> We are trying to install Reporting Services on a server and we are
getting
> this error.
> ReportServicesConfigUI.WMIProvider.WMIProviderException: The version does
> not match a supported version.
> at
>
ReportServicesConfigUI.WMIProvider.RSReportServerAdmin.GenerateDatabaseUpgra
deScript(String databaseName, String serverVersion, String& script)
> just to be sure, it that mean the version of SQL Server we have will not
> allow Reporting services to be installed or is it something else that
cause
> the error?
> We have SQL Server Enterprise 64x.
>sql
this error.
ReportServicesConfigUI.WMIProvider.WMIProviderException: The version does
not match a supported version.
at
ReportServicesConfigUI.WMIProvider.RSReportServerAdmin.GenerateDatabaseUpgradeScript(String databaseName, String serverVersion, String& script)
just to be sure, it that mean the version of SQL Server we have will not
allow Reporting services to be installed or is it something else that cause
the error?
We have SQL Server Enterprise 64x.On Dec 13, 9:02 am, Ben <B...@.discussions.microsoft.com> wrote:
> We are trying to install Reporting Services on a server and we are getting
> this error.
> ReportServicesConfigUI.WMIProvider.WMIProviderException: The version does
> not match a supported version.
> at
> ReportServicesConfigUI.WMIProvider.RSReportServerAdmin.GenerateDatabaseUpgradeScript(String databaseName, String serverVersion, String& script)
> just to be sure, it that mean the version of SQL Server we have will not
> allow Reporting services to be installed or is it something else that cause
> the error?
> We have SQL Server Enterprise 64x.
It seems like your SQL Server version is different than your SSRS
version. This link might help. http://207.46.236.188/MSDN/ShowPost.aspx?PostID=2294611&SiteID=1
Regards,
Enrique Martinez
Sr. Software Consultant|||Are you trying to do a fresh install of Reporting Services or are you just
now trying to configure it?
If you are trying to configure it make sure that when you installed SRS
from the SQL Server 2005 media that you re-applied any service packs that
you put on SQL Server 2005 before installing Reporting Services. This can
happen when the current installation is at an SP1 or SP2 level yet the
installed files from SRS are at an RTM level.
If it is a "Fresh" install of SRS see if you can select the radio button
that says "Configure Later" rather than the "Common Configuration" button.
This will allow you to do all of the configuration steps after SRS has
installed. This will allow you to apply any SPs necessary before you try
and configure SRS.
Also, if you are trying to upgrade an instance of SQL Server 2000 SRS you
can always upgrade the database AFTER you have installed 2005 SRS. You
don't have to upgrade the existing instance of SRS all you actually need is
the database. Just make sure you exported the encryption key for the
database from the old SRS 2000 instance before doing that. (You can do this
by using the rskeymgmt tool in the 80\tools\binn folder. Just do a
rskeymgmt -? and look for the key export example)
--
Chris Alton, Microsoft Corp.
SQL Server Developer Support Engineer
This posting is provided "AS IS" with no warranties, and confers no rights.
--
> Thread-Topic: Problems Initializing Reporting Serivices
>
> We are trying to install Reporting Services on a server and we are
getting
> this error.
> ReportServicesConfigUI.WMIProvider.WMIProviderException: The version does
> not match a supported version.
> at
>
ReportServicesConfigUI.WMIProvider.RSReportServerAdmin.GenerateDatabaseUpgra
deScript(String databaseName, String serverVersion, String& script)
> just to be sure, it that mean the version of SQL Server we have will not
> allow Reporting services to be installed or is it something else that
cause
> the error?
> We have SQL Server Enterprise 64x.
>sql
problems in sql server 2005 installation
Hello everybody
Ok the problem is that i have sql 2000 in a computer with windows 2000 professional sp4. i'm trying to install the sql server 2005 in other instance. When the installation begins i don't have any problem, but when it ends, y try to enter to the manage studio and is not in the start menu. Sql 2000 is ok but i can't work in 2005 i reinstall both versions but the problem persist. I delete all the files in the instalation but when i install it again the problem apperas again. how can i install both versions?
Did you install SQL Express? There is no Management Studio in the setup, download it separately from here: http://www.microsoft.com/downloads/details.aspx?FamilyId=C243A5AE-4BD1-4E3D-94B8-5A0F62BF7796&DisplayLang=en
--
SvenC
problems in installing sql server 2000 standard edition
When i install sql server 2000 i have a message
" Microsoft SQL Server 2000 Standard Edition Server Component is not supported on this operating system only client components will be available for installation"
" Microsoft SQL Server 2000 Standard Edition Server Component is not supported on this operating system only client components will be available for installation"
Hence I cannot install properly. I installed only the client componets. Thereafter when I went through Enterprise Manager and tried to establish a connection, I failed. It said server does not exist.
What to do now?
I found out that if one has sql server 2000 standard editon the prerequisties are
Microsoft Windows NT Server 4.0 with Service Pack 5 or later, Windows NT Server 4.0 Enterprise Edition with Service Pack 5 or later, Windows 2000 Server, Windows 2000 Advanced Server, or Windows 2000 Datacenter Server.
I have windows xp professional version on which i am installing sql server standard edition.
Which of the above exists in my OS. Or which should I download.
Thanks
You can only install SQL Server full editions (such as Standard, Enterprise, etc) on "server" OSes, such as those listed in your original message. On "client" OSes such as XP, you can only install the client tools to connect to other server machines. Thus in order to install SQL 2000, you will need Windows 2000, 2003, or Vista. Same story with SQL 2005.
Thanks,
Sam Lester (MSFT)
Monday, March 26, 2012
Problems during the installation of Integration Services
Trying to install SQL Server 2005 on my machine,I installed each part (engine, reporting services, integration services etc) seperately.
During the installation of Integration Services I got the following message
failed to install and configure assemblies D:\Microsoft SQL Server 90\90\DTS\Tasks\Microsoft.Sqlserver.MSMQTasks.dll in the COM+ catalog. Error: -2146233087
ErrorMessage: Unknown Error 0x80131501
ErrorDescription: You must have administrative credentials to perform this task. Contact your system administrator for assistance
I am administrator of my machine an i tried to install SQL usign this account.
I selected IGNORE and the installation continued. Will I have any problem with Integration Services in the future because of this error?
What is the source of this problem? How could I solve this problem?
Thank You Very Much
I had the same problem but i didnt find any solution.
Did you? Could you please post the solution when you find it?
Thank you
|||I, too, am getting the same error under the same circumstances (logged in with admin priviledges). Using the help button on the error notification sent me to a web page to directs the user to confirm that the Distributed Transaction Coordinator service is logged in as "Network Service", which it is, so the help advice was useless.
Does anyone know the real source of this error?
Thanks
|||What OS?|||I'm running XP Pro and Studio 2005 .NET. I found a different note that suggested uninstalling SQL Server, Studio and, .NET, and then reinstalling in that order. I'd really like to avoid uninstalling Studio if possible, though.
I did go back and uninstall all SQL servers (SQL Express was previously installed), and attempt the SQL 2005 install again and got the same error. I pressed "Ignore" and the complete install proceeded to the end without a problem. However, I suspect that MSMQTask.dll, the file that was causing the error, is going to needed at some point and I'll get failures.
Thanks
|||I'm getting the same problem with XP Pro.I'm surprised it took 6 months for anybody showing interest in this problem. Usually this forum is awesome for solutions.
- Thanks.
Problems during the installation of Integration Services
Trying to install SQL Server 2005 on my machine,I installed each part (engine, reporting services, integration services etc) seperately.
During the installation of Integration Services I got the following message
failed to install and configure assemblies D:\Microsoft SQL Server 90\90\DTS\Tasks\Microsoft.Sqlserver.MSMQTasks.dll in the COM+ catalog. Error: -2146233087
ErrorMessage: Unknown Error 0x80131501
ErrorDescription: You must have administrative credentials to perform this task. Contact your system administrator for assistance
I am administrator of my machine an i tried to install SQL usign this account.
I selected IGNORE and the installation continued. Will I have any problem with Integration Services in the future because of this error?
What is the source of this problem? How could I solve this problem?
Thank You Very Much
I had the same problem but i didnt find any solution.
Did you? Could you please post the solution when you find it?
Thank you
|||I, too, am getting the same error under the same circumstances (logged in with admin priviledges). Using the help button on the error notification sent me to a web page to directs the user to confirm that the Distributed Transaction Coordinator service is logged in as "Network Service", which it is, so the help advice was useless.
Does anyone know the real source of this error?
Thanks
|||What OS?|||I'm running XP Pro and Studio 2005 .NET. I found a different note that suggested uninstalling SQL Server, Studio and, .NET, and then reinstalling in that order. I'd really like to avoid uninstalling Studio if possible, though.
I did go back and uninstall all SQL servers (SQL Express was previously installed), and attempt the SQL 2005 install again and got the same error. I pressed "Ignore" and the complete install proceeded to the end without a problem. However, I suspect that MSMQTask.dll, the file that was causing the error, is going to needed at some point and I'll get failures.
Thanks
|||I'm getting the same problem with XP Pro.I'm surprised it took 6 months for anybody showing interest in this problem. Usually this forum is awesome for solutions.
- Thanks.
Subscribe to:
Posts (Atom)