Greetings
We're having trouble getting the Agent started. The service is set to login as NT AUTHORITY/System. In an effort to attempt to diagnose the problem we changed the service (using Service Control Manager) to login as a user with Administrator rights on the server and we got the same error, except for that user.
[298] SQLServer Error: 18456 Login failed for user NT AUTHORITYSYSTEM [SQL STATE 28000]
[298] SQL Server Error: 4060 Cannot open database "EP_SessionState" requested by the login. The login failed [SQL STATE 42000]
I'm sure this is a common problem with an easy solution however I can not find out much about EP_SessionState through Google and was hoping someone could help.
This seems to happen just after our backups run. the result is that the SQL Server Enterprise Manager can be brought up the next day but nothing can be accessed or inquired of. The service is still running, the server is still up and rebooting the server resolves the problem.
98/08/06 20:32:31.68 kernel dpdb_asyncread: mirror: Operating system error 6 (The handle is invalid.) encountered
Is anybody else using Arcserve Backup Agent for SQL Server for Windows NT, RAID 5? Have you seen this? I`ve been to MS home page and on technet. No mention of this problem. Next stop is Arcserve home page, if they have one. I have read the error logs and this is the second time this has happened this week. Both times since we added Arcserve to manage our MS SQL Server Database backups.
I have spent all day reading microsoft material and reading through this site to figure out what is wrong with my schedule job without success. I have come to the point where I can't take it no more. Would someone pleaseee help out a sister?
This is the situation: I created a very simple package on my server A. This package pull data from server B and load into server C:
B====> C
I deployed and copy and install the package successfully to the target server c. When
Now, I can run the package from either MSDB and file system storage.
My problem is when I schedule this package. It failed with the log below.
All my server are on the same domain and I have a domain account. When I schedule and run the job with my domain account, I get the following error: I have administrative rights in all the servers.
Job Name DW_DataImport Step Name (Job outcome) Duration 00:00:00 Sql Severity 0 Sql Message ID 0 Operator Emailed Operator Net sent Operator Paged Retries Attempted 0
Message The job failed. Unable to determine if the owner (Weblogeomon) of job Dw_DataImport has server access (reason: Could not obtain information about Windows NT group/user 'Weblogeomon', error code 0x5. [SQLSTATE 42000] (Error 15404) The statement has been terminated. [SQLSTATE 01000] (Error 3621)).
When I change it to sa, I get the following:
Date 3/16/2006 2:25:05 PM Log Job History (Dw_DataImport)
Step ID 0 Server DW_Server3 Job Name Dw_DataImport Step Name (Job outcome) Duration 00:01:55 Sql Severity 0 Sql Message ID 0 Operator Emailed Operator Net sent Operator Paged Retries Attempted 0
Message The job failed. The Job was invoked by User sa. The last step to run was step 1 (Dw_DataImport).
Worst yet, I created
CREATE CREDENTIAL [SSISCredential] WITH IDENTITY = 'Weblogeomon',
I have been trying to set up transactional replication between an OLTP SQL Server 2005 Standard edition server and a BI SQL Server 2005 Enterprise edition server. I am using a pull subscription. I was able to establish the replication from the developement server to the BI server however when I tried setting up the replication between the production environment and the BI server, using the same configuration settings, I ran into a problem. The production server had been renamed after it was initially set up. I used the sp_dropserver and sp_addserver to solve this issue and was able to run the replication wizard. However once the wizard finishes the snapshot agent doesn't initialize the publication. When I look at the replication monitor it has a status of "never run". I try to run it manually and it appears to run for a few seconds then stops and still has the status of "never run". I don't get any error messages and can't find anything in the log. I am wondering if this is related to the server rename? I am hoping to find a soultion that doesn't involve uninstalling SQL Server and reinstalling since this is a production environment.
I'm trying to deploy a SSIS package and am having issues getting it to execute from a SQL Agent job. I've read this article http://support.microsoft.com/?kbid=918760 over and over and although it's helpful I must still be missing something.
The SSIS package uses a configuration file for connection string information and the ProtectionLevel is set to DontSaveSensitive. I'm using a proxy account with the appropriate permissions. I can execute the package from SQL Management Studio and from dtexec.exe just fine. I even copied the command line out of the job and used that to execute it with dtexec.exe and it worked.
I'm not sure what to try next. It's like it's not even getting to the SSIS package. I have logging turned on in the package and I"m not getting back any errors from it. Any ideas? One thing that I think is strange is that the job is running on an instance of SQL but Integration Services doesn't seem to support instances. Could that be the issue?
I don't know what else to try at this point...any advice is greatly appreciated!
This is on sql server 2005: I created an agent job and I want to be able to notify people by email when it completes and when it fails. I first wanted to test the notification for when it completes. I created an operator and entered the E-mail name. In the job properties, I selected this operator in the Notifications page.
The job runs an ETL process. When I run the job, after it completes, the email is not sent. This seems straight-forward. The email address is valid, I tested the email address and it does get sent when I do it from Outlook 2007.
when I run a package from a command window using dtexec, the job immediately says success. DTExec: The package execution returned DTSER_SUCCESS (0). Started: 3:37:41 PM Finished: 3:37:43 PM Elapsed: 2.719 seconds
However the Job is still in th agent and the status is executing. The implications of this are not good. Is this how the sql server agent job task is supposed to work by design.
We just moved source server to newer, bigger box ... Windows 2003 and Active Directory ... Snapshot agent worked but distribution failed ... Same login as on older machine, login is sysadm, used DCOMCNFG to allow ability to launch process ... What are we missing?
Hey - I'm having a bit of trouble getting this website to run off of my local host. I'm running IIS with SQL Server Express. Here's the connection info from the Web.config file in the website... <sessionState mode="InProc" stateConnectionString="tcpip=127.0.0.1:42424" sqlConnectionString="data source=127.0.0.1;user id=sa;password=asdf" cookieless="false" timeout="20" /> ...and here's the error I'm getting...An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) Stack Trace: An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)]System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +739123System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +188System.Data.SqlClient.TdsParser.Connect(ServerInfo serverInfo, SqlInternalConnectionTds connHandler, Boolean ignoreSniOpenTimeout, Int64 timerExpire, Boolean encrypt, Boolean trustServerCert, Boolean integratedSecurity, SqlConnection owningObject) +685966System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, Int64 timerExpire, SqlConnection owningObject) +109System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(String host, String newPassword, Boolean redirectedUserInstance, SqlConnection owningObject, SqlConnectionString connectionOptions, Int64 timerStart) +349System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance) +181System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance) +170System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection) +359System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options) +28System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject) +424System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject) +66System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) +496System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) +82System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) +105System.Data.SqlClient.SqlConnection.Open() +111kpl_testweb.Eventcal.bind_ddlocation() in E:WebsR2G2007controlsEventcal.ascx.vb:131kpl_testweb.Eventcal.Page_Load(Object sender, EventArgs e) in E:WebsR2G2007controlsEventcal.ascx.vb:94System.Web.UI.Control.OnLoad(EventArgs e) +98System.Web.UI.Control.LoadRecursive() +71System.Web.UI.Control.LoadRecursive() +154System.Web.UI.Control.LoadRecursive() +154System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +4310any tips for me? I'm not even sure where to start here...
I downloaded a sample blog sample from Scot Mitchel and wanted to try it out. I attached the .mdf file to SQL Server 2005 but noticed that, when I create users they don't come into the database that I attached, though all the necessary aspnet_ tables are in there but in the dedicated table I didn't see any new user. My dedicated database (LocalSqlServer) is in another database. I have the connectionstring made up in the machine.config file in the LocalSqlServer name.So I thought that the web.config does override the settings in the machine.config I could easily place this in my web.config:<remove name="LocalSqlServer"/> <add name="LocalSqlServer" connectionString="Data Source=TESTINGDBSERVER;Initial Catalog=ScotBlog;Integrated Security=True" providerName="System.Data.SqlClient"/>But that too doesn't do the trick. Does anyone have an anwser on what's going wrong here? And especially how I can solve this...
I am trying to install SQL server 6.5 for my SMS server. The installation stops with the message "could not connect to SQL server". There was evaluation version of SQL server 6.5 previously in the same server. I doubt that it was completely removed as when I try the upgrade option instead of install option, I get a message " early beta version of SQL server 6.5 detected". I am unable to use the deinstall option in the setup as it is dimmed. How do I completely remove all the files and registry entries so that I can do a fresh install?
I have run sql server 2000 and analysis manager on my laptop for a few months with no probs. On Monday I tried to connect to my computer server from sql server ent manager and it said "no datasource found." and something else about MS ODBC drivers being invalid. Analysis services still worked fine. I tired to connect and add servers and it just would not recognise anything so became software I could not use at all. I then uninstalled all sql server products on my computer. I thought a fresh reinstall would do the job. However now when I try to install sql server I get an error in the installation. It says that it cannot connect to the datasource and installation fails. It tells me to look in a sqlstp log and the bottom of this log is below
15:50:25 Begin Action: DialogShowSdUninstall 15:50:28 ShowDlgUninstall returned : 1 15:50:28 End Action DialogShowSdUninstall 15:50:28 Dialog 0x80000000 returned: 1 15:50:28 End Action ShowDialogsHlpr 15:50:28 ShowDialogsGetDialog returned: nCurrent=0x0,index=0 15:50:28 End Action ShowDialogs 15:50:29 Action CleanUpInstall: 15:50:29 StatsGenerate returned: 2 15:50:29 StatsGenerate (0xc0200805,0x2,0xf000000,0x400,1033,303,0x2,0x1,0 ,0,0 15:50:29 StatsGenerate -1,rj) 15:50:29 Installation Failed.
I havent shown the rest of the log because there is a lot of it. If needed I can copy in the rest.
The rest of the installation up to this point seems fine. HOwever it doesnt install the unistall files so I cannot uninstall SQL Server now. There is 105 MB of the program on my computer which I can only delete although I havent done this yet.
Why wont sql server let me install? It is a really annoying problem because it worked fine last Friday and then on Monday it went wrong and I cannot remember doing anything to make this happen. All MS updates are up-to-date. Any help is greatly appreciated
I am having trouble using the CONTAINS function in sqlserver(enterprise manager). I am typing the following:Select *FROM mytableWHERE CONTAINS(myfield,'mystring')This returns the error:Query Designer encountered a MS Design Tools error:ODBC error:[Microsoft][ODBC SQL Server Driver]'CONTAINS' is not arecognizedfunction name.[Microsoft][ODBC SQL Server Driver][SQLServer]Statement(s) couldnot be prepared.According to the T-SQL reference on msdn this is a supported function?Am I typing something incorrectly? If this is not supported, isthere an equivalent to this function? In my field I have some commadelimited values ie 'apple,orange'. So I need to be able to discernwhich records contain orange. The LIKE keyword doesn't seem to workfor this scenario. Any help would be greatly appreciated.
Above are the errors that i get when im tryin to install SQL 2005 i think its the DATA base side of it i managed to install the Configuration tools and things just cant install the Data base side where u can actually do something with it.
I am getting an error saying incorrect syntax near fIt works in SQL Server 2005, but I cannot get it to work in SQL Server 2000 The error appears to be in the section that I marked in Bold. CREATE PROCEDURE [dbo].[pe_getReport] -- Add the parameters for the stored procedure here @BranchID INT, @InvestorID INT, @Status INT, @QCAssigned INT, @LoanOfficer nvarChar(40), @FromCloseDate DateTime, @ToCloseDate DateTime, @OrderBy nvarChar(50)ASDECLARE @l_Sql NVarChar(4000), @l_OrderBy NVarChar(500), @l_OrderCol NVarChar(150), @l_CountSql NVarChar(4000), @l_Where NVarChar(4000), @l_SortDir nvarChar(4)BEGIN -- SET NOCOUNT ON added to prevent extra result sets from -- interfering with SELECT statements. SET NOCOUNT ON; SET @l_Where = N' Where 1=1' IF (@BranchID IS NOT NULL) SET @l_Where = @l_Where + N' AND f.BranchID=' + CAST(@BranchID As NVarChar) IF (@Status IS NOT NULL) SET @l_Where = @l_Where + N' AND f.Status=' + CAST(@Status As NVarChar) IF (@InvestorID IS NOT NULL) SET @l_Where = @l_Where + N' AND f.InvestorID=' + CAST(@InvestorID As NVarChar) IF (@QCAssigned IS NOT NULL) SET @l_Where = @l_Where + N' AND f.QCAssigned=' + CAST(@QCAssigned As NVarChar) IF (@LoanOfficer IS NOT NULL) SET @l_Where = @l_Where + N' AND f.LoanOfficer LIKE ''' + @LoanOfficer + '%''' IF (@FromCloseDate IS NOT NULL) SET @l_Where = @l_Where + N' AND f.ClosingDate>=''' + CAST(@FromCloseDate AS NVarChar) + '''' IF (@ToCloseDate IS NOT NULL) SET @l_Where = @l_Where + N' AND f.ClosingDate<=''' + CAST(@ToCloseDate AS NVarChar) + '''' IF @OrderBy IS NULL SET @OrderBy = 'DateEntered DESC' SET @l_SortDir = SUBSTRING(@OrderBy, CHARINDEX(' ', @OrderBy) + 1, LEN(@OrderBy)) SET @l_OrderCol = SUBSTRING(@OrderBy, 1, NULLIF(CHARINDEX(' ', @OrderBy) - 1, -1)) IF @l_OrderCol = 'InvestorName' SET @l_OrderBy = 'i.InvestorName ' + @l_SortDir ELSE IF @l_OrderCol = 'BName' SET @l_OrderBy = 'b.BName ' + @l_SortDir ELSE IF @l_OrderCol = 'StatusDesc' SET @l_OrderBy = 's.StatusDesc ' + @l_SortDir ELSE IF @l_OrderCol = 'QCAssigned' SET @l_OrderBy = 'q.LoginName ' + @l_SortDir ELSE SET @l_OrderBy = 'f.' + @l_OrderCol + ' ' + @l_SortDir SET @l_CountSql = 'SELECT f.FundedID As FundedID FROM FundedInfo AS f LEFT OUTER JOIN Investors AS i ON f.InvestorID = i.InvestorID LEFT OUTER JOIN Branches AS b ON f.BranchID = b.BranchID LEFT OUTER JOIN Status AS s ON f.Status = s.StatusID LEFT OUTER JOIN QCLogins AS q f.QCAssigned = q.LoginID ' + @l_Where + ' ORDER BY ' + @l_OrderBy CREATE TABLE #RsltTable (ID int IDENTITY PRIMARY KEY, FundedID int) INSERT INTO #RsltTable(FundedID) EXECUTE (@l_CountSql)SELECT f.DateEntered As DateEntered, f.LastName As LastName, f.LoanNumber As LoanNumber, f.LoanOfficer As LoanOfficer, f.ClosingDate As ClosingDate, i.InvestorName As InvestorName, b.BName As BName, s.StatusDesc As StatusDesc, q.LoginName As LoginNameFROM FundedInfo AS f LEFT OUTER JOIN Investors AS i ON f.InvestorID = i.InvestorID LEFT OUTER JOIN Branches AS b ON f.BranchID = b.BranchID LEFT OUTER JOIN Status AS s ON f.Status = s.StatusID LEFT OUTER JOIN QCLogins As q ON f.QCAssigned = q.LoginID WHERE FundedID IN(SELECT FundedID FROM #rsltTable) ORDER BY CASE @OrderBy WHEN 'DateEntered ASC' THEN f.DateEntered END ASC, CASE @OrderBy WHEN 'DateEntered DESC' THEN f.DateEntered END DESC, CASE @OrderBy WHEN 'LastName ASC' THEN f.LastName END ASC, CASE @OrderBy WHEN 'LastName DESC' THEN f.LastName END DESC, CASE @OrderBy WHEN 'LoanNumber ASC' THEN f.LoanNumber END ASC, CASE @OrderBy WHEN 'LoanNumber DESC' THEN f.LoanNumber END DESC, CASE @OrderBy WHEN 'LoanOfficer ASC' THEN f.LoanOfficer END ASC, CASE @OrderBy WHEN 'LoanOfficer DESC' THEN f.LoanOfficer END DESC, CASE @OrderBy WHEN 'ClosingDate ASC' THEN f.ClosingDate END ASC, CASE @OrderBy WHEN 'ClosingDate DESC' THEN f.ClosingDate END DESC, CASE @OrderBy WHEN 'InvestorName ASC' THEN i.InvestorName END ASC, CASE @OrderBy WHEN 'InvestorName DESC' THEN i.InvestorName END DESC, CASE @OrderBy WHEN 'BName ASC' THEN b.BName END ASC, CASE @OrderBy WHEN 'BName DESC' THEN b.BName END DESC, CASE @OrderBy WHEN 'StatusDesc ASC' THEN s.StatusDesc END ASC, CASE @OrderBy WHEN 'StatusDesc DESC' THEN s.StatusDesc END DESC, CASE @OrderBy WHEN 'LoginName ASC' THEN q.LoginName END ASC, CASE @OrderBy WHEN 'LoginName DESC' THEN q.LoginName END DESCENDGO
I am really new to SQL Server. I have trying to create/register a server. I came to know that I need to go to Query Analayser and then register a Server. Then in Enterprise Manager I need to register a Group. I did everything.
But...
Here is the error.
Unable to connect server. Server: Msg 17, Level 16, State 1
[Microsoft] [ODBC SQL Server Driver] [Shared Memory]
SQL Server does not exit or access denied.
I really appreciate if u can give me steps. Thanks, Padma.
Hi, i am trying to get to my hosting companies database server. Its SQL Sever 2000, but i want to connect through SQL Server Management Studio 2005. The connection is unable to be established, although i have tried all sorts of settings for the connection. I called the hosting company and they told me to connect using the IP address of the name server for my domain. It failed and i called again to check back, and one of the guy told me that u cannot connect to an instance of sql servr 2000 from sql server 2005. Is this true? Please help.
Here is the information that I have... ( ps all information is not the actuall information )
1) URL abc.somehostingcompany.com IP: 211.11.111.1 PORT: 1433 ( NOTE: if I go to a cmd promt and type in ping abc.somehostingcompany.com I get a response )
2) dbname = mydatabase
3) userUid = sa pwd = sa
Inside SQL Server Configuration Manager --> SQL Server Network Configuration --> Protocols for SQLEXPRESS, I enabled TCP/IP and Shared Memory. Inside the properties of TCP / IP, I made sure under the "IP Address" tab that the
IP1: Active = yes
IP1: Enabled = yes
IP1: IP Address = abc.somehostingcompany.com
IP1: TCP Dynamic Ports = 0
IP1: TCP Port = < empty string >
I clicked "OK", and I stopped and started the SQL Server 2005 Services --> SQL Server (SQLEXPRESS). Then I started up SQL Server Brower.
Lastly I go to SQL Server Management Studio Express and try to connect to this remote server and database and I keep getting timeout issues and a message saying that the default settings for SQL Server Express do not allow remote connectioning by default.
Any ideas what I could be doing wrong? Should I use the port number instead of Dynamic Ports? Should I use the real IP address? Does the LOG ON AS under SQL Server (SQLEXPRESS) properties need to be updated?
I am trying to connect to SQL Server Express using the following VB code from an aspx.vb page: ' Create and open a connection to the database Dim conn As New SqlConnection("Data Source=YOUR-FE632222CE\SQLEXPRESS;Initial Catalog=scotfree;Integrated Security=SSPI") conn.Open() This code fails on conn.Open() however giving me the following exception:System.InvalidOperationException: Instance failure.Stack trace:[InvalidOperationException: Instance failure.] System.Data.SqlClient.TdsParser.Connect(Boolean& useFailoverPartner, Boolean& failoverDemandDone, String host, String failoverPartner, String protocol, SqlInternalConnectionTds connHandler, Int64 timerExpire, Boolean encrypt, Boolean trustServerCert, Boolean integratedSecurity, SqlConnection owningObject, Boolean aliasLookup) +1804 System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance) +606 System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance) +193 System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection) +501 System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options) +28 System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject) +429 System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject) +70 System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) +512 System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) +85 System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) +89 System.Data.SqlClient.SqlConnection.Open() +160 Default3.OnLoad(EventArgs e) in C:Documents and SettingsLiamMy DocumentsVisual Studio 2005WebSitesTestDefault3.aspx.vb:15 System.Web.UI.Control.LoadRecursive() +49 System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +3743The strange thing is that I replicated the code in C# and it works fine. Any ideas.
HiI recently installed MS SQL Server 2005 Developer Ed. w/ SP2 on my XP... I use VS2005 to create personal websites. I was previously using SQL Server Express, and things worked fine by default settings. I am a beginner to web development and I really don't know anything about SQL Server. I'm guessing it needs to be configured somehow to work with VS, but I have no idea how to do that. I have an existing Web App which uses a database for login functionality, and everytime I try and log on I get this message:An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)I made sure that the Server's database engine accepts remote connections but that didn't help. Does anyone have any suggestions?~Miro
I have been trying to create a link from 7.0 to 6.5, I dont know what i am doing wrong. I tried almost all the combination. Will somebody walk me thru the process.
I recently installed VISUAL STUDIO .NET 2003 and SQL SERVER 2000 personal edition on my XP system. I also applied service pack 3a to it. I use windows integrated security, and server runs from it's system account (SA). The problem is that I cannot create tables, views, procedures or databases from SERVER EXPLORER. I can do it through Enterprise Manager. When I install destop engine instead of sql server it's OK, but when it's SQL server personal edition, then it's a problem. I tried giving my account, and my account group (builtin/administrators) all rights and privilegies I could think of, but it still doesn't work. I did not have this problem vith previous version of Visual Studio .net. I think it's something about security and permissions. Any suggestions ? Thx in advance.........
Hello everyone. Pretty new to SQL Server and i've run into some trouble with something I am attempting to do.
Basically, we imported one of our databases on one of our SQL Servers to a new sql server that we just setup. That went ok with no problems. The DB is now in the new SQL Server.
Now, we need to copy the contents of a second DB from the original server into this new sql server DB. For reference:
We imported a DB Called: siebeldb We want to import/overwrite another DB into that same DB. We backedup the DB and moved the file to the new SQL server.
So:
Import/Restore: sbprd01(a backup file) into siebeldb
I hope that makes sense.
I have the following command that I am trying to execute in the SQL Query analyzer:
RESTORE DATABASE siebeldb FROM DISK='C:Documents and SettingsAdministratorDesktopsiebelprddb092509.bak' WITH MOVE 'siebelprddb_Data' TO 'C:Program FilesMicrosoft SQL ServerMSSQLDatasiebeldb_Data.mdf', MOVE 'siebelprddb_Log' TO 'C:Program FilesMicrosoft SQL ServerMSSQLDatasiebeldb_Log.mdf', REPLACE
It is running right now, but seems to be running into errors. I just added the 'REPLACE' option according to the t-sql reference guide.
Does my script look ok? Am I doing anything wrong?
I am trying to install SQL Server 2005. I just installed Microsoft Visual Studio 2005(.NET). I got an option in my Start -> Programs for Microsoft SQL Server 2005. But I don't see how to bring up the query analyzer. It just has options for Configuration Tools ->SQL Server Configuration Manager,SQL Server Error and Usage Reporting, SQL Server Surface Area Configuration.
Did I install it wrong by chance? Do I need to do something else now? Do I need to configure it? If yes, how do I do that? Could anyone lead me in the right direction please? Thanks!
I have no idea how to proceed since I've never installed this before. Could anyone please help me install or do whatever needs to be done to it so I can bring up the query analyzer/user interface and be able to use SQL?
I'm currently trying to establish a linked server to an Oracledatabase.Setup:Connecting to 8x version of OracleUsing 9i client tools (Net Manager)SQL-Server 2000Windows 2000I installed the Oracle 9i client tools, and set up a Service for theOracle connection. Testing from the 9i client produces a successfullconnection.I then opened SQL-Server and created a new Linked Server with thefollowing setup:Name - PYR_LinkProvider - Microsoft OLE DB Provider for OracleProduct Name - PYRData Source - PYR (9i Service Name)Provider string - MSDAORAI get the unspecific 7399 error that OLE DB provider MSDAORA reportedan error, trace 'Initialize returned 0x80004005'I've searched through the archives, checked all of the relevantMicrosoft articles I could find, and still have no idea what is wrong.SQL-Server reports that the provider is registered in the system, but Ican't figure out what I'm missing.Help or a guide for troubleshooting would be much appreciated.Tim
When trying to install SP4, I do not receive any notification of the install i.e. click on setup and then nothing. Checked *.out log and receive the following:
2006-08-08 10:40:57 - ? [100] Microsoft SQLServerAgent version 8.00.194 (x86 unicode retail build) : Process ID 3616 2006-08-08 10:40:57 - ? [101] SQL Server 1LTZ0Q version 8.00.194 (0 connection limit) 2006-08-08 10:40:57 - ? [102] SQL Server ODBC driver version 3.81.9031 2006-08-08 10:40:57 - ? [103] NetLib being used by driver is DBMSSHRN.DLL; Local host server is (local) 2006-08-08 10:40:57 - ? [310] 2 processor(s) and 1016 MB RAM detected 2006-08-08 10:40:57 - ? [339] Local computer is 1LTZ0Q running Windows NT 5.0 (2195) Service Pack 4 2006-08-08 10:40:57 - ? [129] SQLSERVERAGENT starting under Windows NT service control 2006-08-08 10:40:57 - + [260] Unable to start mail session (reason: No mail profile defined) 2006-08-08 10:40:57 - + [396] An idle CPU condition has not been defined - OnIdle job schedules will have no effect
Novice - Where to set up the mail profile and CPU idle condition?
I am having trouble installing SQL Server 2005 on a new machine at a hosted company. I am only installing the minimum, SQL Databaes Services. It errors out at the end and says see log. I have installed SQl 2005 10 times with no problem at other locations. The service won't even start it says error 3 path unkown. If I look for the path it shows in the service it hasn't been created, the files and directories were not created at that directory location. I tried to install bot as a Domain Admin and Local Admin accounts.
Here THe summary Log., Core(local) and Core Log files below.
Microsoft SQL Server 2005 9.00.1399.06 ============================== OS Version : Microsoft Windows Server 2003 family, Standard Edition Service Pack 1 (Build 3790) Time : Tue Mar 20 02:48:40 2007
Machine : CATCSAP021211 Product : Microsoft SQL Server Setup Support Files (English) Product Version : 9.00.1399.06 Install : Successful Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0016_CATCSAP021211_SQLSupport_1.log -------------------------------------------------------------------------------- Machine : CATCSAP021211 Product : Microsoft SQL Server Native Client Product Version : 9.00.1399.06 Install : Successful Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0016_CATCSAP021211_SQLNCLI_1.log -------------------------------------------------------------------------------- Machine : CATCSAP021211 Product : Microsoft Office 2003 Web Components Product Version : 11.0.6558.0 Install : Successful Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0016_CATCSAP021211_OWC11_1.log -------------------------------------------------------------------------------- Machine : CATCSAP021211 Product : Microsoft SQL Server VSS Writer Product Version : 9.00.1399.06 Install : Successful Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0016_CATCSAP021211_SqlWriter_1.log -------------------------------------------------------------------------------- Machine : CATCSAP021211 Product : Microsoft SQL Server 2005 Backward compatibility Product Version : 8.05.1054 Install : Successful Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0016_CATCSAP021211_BackwardsCompat_1.log --------------------------------------------------------------------------------
SQL Server Setup failed. For more information, review the Setup log file in %ProgramFiles%Microsoft SQL Server90Setup BootstrapLOGSummary.txt.
Microsoft SQL Server 2005 Setup beginning at Mon Mar 19 19:49:04 2007 Process ID : 1300 C:Program FilesMicrosoft SQL Server90Setup Bootstrapsetup.exe Version: 2005.90.1399.0 Running: LoadResourcesAction at: 2007/2/19 19:49:4 Complete: LoadResourcesAction at: 2007/2/19 19:49:4, returned true Running: ParseBootstrapOptionsAction at: 2007/2/19 19:49:4 Loaded DLL:C:Program FilesMicrosoft SQL Server90Setup Bootstrapxmlrw.dll Version:2.0.3604.0 Complete: ParseBootstrapOptionsAction at: 2007/2/19 19:49:4, returned true Running: ValidateWinNTAction at: 2007/2/19 19:49:4 Complete: ValidateWinNTAction at: 2007/2/19 19:49:4, returned true Running: ValidateMinOSAction at: 2007/2/19 19:49:4 Complete: ValidateMinOSAction at: 2007/2/19 19:49:4, returned true Running: PerformSCCAction at: 2007/2/19 19:49:4 Complete: PerformSCCAction at: 2007/2/19 19:49:4, returned true Running: ActivateLoggingAction at: 2007/2/19 19:49:4 Complete: ActivateLoggingAction at: 2007/2/19 19:49:4, returned true Running: DetectPatchedBootstrapAction at: 2007/2/19 19:49:4 Complete: DetectPatchedBootstrapAction at: 2007/2/19 19:49:4, returned true Action "LaunchPatchedBootstrapAction" will be skipped due to the following restrictions: Condition "EventCondition: __STP_LaunchPatchedBootstrap__1300" returned false. Action "BeginBootstrapLogicStage" will be skipped due to the following restrictions: Condition "Setup is running locally." returned true. Running: PerformDotNetCheck2 at: 2007/2/19 19:49:4 Complete: PerformDotNetCheck2 at: 2007/2/19 19:49:4, returned true Running: InvokeSqlSetupDllAction at: 2007/2/19 19:49:4 Loaded DLL:C:Program FilesMicrosoft SQL Server90Setup Bootstrapsqlspars.dll Version:2005.90.1399.0 <Func Name='DwLaunchMsiExec'> Examining 'sqlspars' globals to initialize 'SetupStateScope' Opening 'MachineConfigScope' for [CATCSAP021211] Trying to find Product Code from command line or passed transform If possible, determine install id and type Trying to find Instance Name from command line. No Instance Name provided on the command line If possible, determine action Machine = CATCSAP021211, Article = WMIServiceWin32OSWorking, Result = 0 (0x0) Machine = CATCSAP021211, Article = WMIServiceWin32CompSystemWorking, Result = 0 (0x0) Machine = CATCSAP021211, Article = WMIServiceWin32ProcessorWorking, Result = 0 (0x0) Machine = CATCSAP021211, Article = WMIServiceReadRegWorking, Result = 0 (0x0) Machine = CATCSAP021211, Article = WMIServiceWin32DirectoryWorking, Result = 0 (0x0) Machine = CATCSAP021211, Article = WMIServiceCIMDataWorking, Result = 0 (0x0) Machine = CATCSAP021211, Article = XMLDomDocument, Result = 0 (0x0) Machine = CATCSAP021211, Article = Processor, Result = 0 (0x0) Machine = CATCSAP021211, Article = PhysicalMemory, Result = 0 (0x0) Machine = CATCSAP021211, Article = DiskFreeSpace, Result = 0 (0x0) Machine = CATCSAP021211, Article = OSVersion, Result = 0 (0x0) Machine = CATCSAP021211, Article = OSServicePack, Result = 0 (0x0) Machine = CATCSAP021211, Article = OSType, Result = 0 (0x0) Machine = CATCSAP021211, Article = iisDep, Result = 0 (0x0) Machine = CATCSAP021211, Article = AdminShare, Result = 0 (0x0) Machine = CATCSAP021211, Article = PendingReboot, Result = 0 (0x0) Machine = CATCSAP021211, Article = PerfMon, Result = 0 (0x0) Machine = CATCSAP021211, Article = IEVersion, Result = 0 (0x0) Machine = CATCSAP021211, Article = DriveWriteAccess, Result = 0 (0x0) Machine = CATCSAP021211, Article = COMPlus, Result = 0 (0x0) Machine = CATCSAP021211, Article = ASPNETVersionRegistration, Result = 0 (0x0) Machine = CATCSAP021211, Article = MDAC25Version, Result = 0 (0x0) ******************************************* Setup Consistency Check Report for Machine: CATCSAP021211 ******************************************* Article: WMI Service Requirement, Result: CheckPassed Article: MSXML Requirement, Result: CheckPassed Article: Operating System Minimum Level Requirement, Result: CheckPassed Article: Operating System Service Pack Level Requirement, Result: CheckPassed Article: SQL Compatibility With Operating System, Result: CheckPassed Article: Minimum Hardware Requirement, Result: CheckPassed Article: IIS Feature Requirement, Result: CheckPassed Article: Pending Reboot Requirement, Result: CheckPassed Article: Performance Monitor Counter Requirement, Result: CheckPassed Article: Default Installation Path Permission Requirement, Result: CheckPassed Article: Internet Explorer Requirement, Result: CheckPassed Article: Check COM+ Catalogue, Result: CheckPassed Article: ASP.Net Registration Requirement, Result: CheckPassed Article: Minimum MDAC Version Requirement, Result: CheckPassed <Func Name='PerformDetections'> 0 <EndFunc Name='PerformDetections' Return='0' GetLastError='0'> <Func Name='DisplaySCCWizard'> CSetupBootstrapWizard returned 1 <EndFunc Name='DisplaySCCWizard' Return='0' GetLastError='183'> Loaded DLL:C:Program FilesMicrosoft SQL Server90Setup Bootstrapsqlsval.dll Version:2005.90.1399.0 <EndFunc Name='DwLaunchMsiExec' Return='0' GetLastError='0'> Complete: InvokeSqlSetupDllAction at: 2007/2/19 19:51:1, returned true Running: SetPackageInstallStateAction at: 2007/2/19 19:51:1 Complete: SetPackageInstallStateAction at: 2007/2/19 19:51:1, returned true Running: DeterminePackageTransformsAction at: 2007/2/19 19:51:1 Complete: DeterminePackageTransformsAction at: 2007/2/19 19:51:3, returned true Running: ValidateSetupPropertiesAction at: 2007/2/19 19:51:3 Complete: ValidateSetupPropertiesAction at: 2007/2/19 19:51:3, returned true Running: OpenPipeAction at: 2007/2/19 19:51:3 Complete: OpenPipeAction at: 2007/2/19 19:51:3, returned false Error: Action "OpenPipeAction" failed during execution. Running: CreatePipeAction at: 2007/2/19 19:51:3 Complete: CreatePipeAction at: 2007/2/19 19:51:3, returned false Error: Action "CreatePipeAction" failed during execution. Action "RunRemoteSetupAction" will be skipped due to the following restrictions: Condition "Action: CreatePipeAction has finished and passed." returned false. Running: PopulateMutatorDbAction at: 2007/2/19 19:51:3 Complete: PopulateMutatorDbAction at: 2007/2/19 19:51:3, returned true Running: GenerateRequestsAction at: 2007/2/19 19:51:3 SQL_Engine = 3 SQL_Data_Files = 3 SQL_Replication = 3 SQL_FullText = 3 SQL_SharedTools = 3 SQL_BC_DEP = 3 Analysis_Server = -1 AnalysisDataFiles = -1 AnalysisSharedTools = -1 RS_Server = -1 RS_Web_Interface = -1 RS_SharedTools = -1 Notification_Services = -1 NS_Engine = -1 NS_Client = -1 SQL_DTS = -1 Client_Components = 3 Connectivity = 3 SQL_Tools90 = 3 SQL_WarehouseDevWorkbench = 3 SDK = 3 SQLXML = 3 Tools_Legacy = 3 TOOLS_BC_DEP = 3 SQL_Documentation = 3 SQL_BooksOnline = 3 SQL_DatabaseSamples = -1 SQL_AdventureWorksSamples = -1 SQL_AdventureWorksDWSamples = -1 SQL_AdventureWorksASSamples = -1 SQL_Samples = -1 Complete: GenerateRequestsAction at: 2007/2/19 19:51:4, returned true Running: CreateProgressWindowAction at: 2007/2/19 19:51:4 Complete: CreateProgressWindowAction at: 2007/2/19 19:51:4, returned true Running: ScheduleActionAction at: 2007/2/19 19:51:4 Complete: ScheduleActionAction at: 2007/2/19 19:51:4, returned true Skipped: InstallASAction.11 Skipped: Action "InstallASAction.11" was not run. Information reported during analysis: No install request found for package: "sqlsupport", referred by package: "as", install will be skipped as a result. Skipped: InstallASAction.18 Skipped: Action "InstallASAction.18" was not run. Information reported during analysis: No install request found for package: "owc11", referred by package: "as", install will be skipped as a result. Skipped: InstallASAction.22 Skipped: Action "InstallASAction.22" was not run. Information reported during analysis: No install request found for package: "bcRedist", referred by package: "as", install will be skipped as a result. Skipped: InstallASAction.9 Skipped: Action "InstallASAction.9" was not run. Information reported during analysis: No install request found for package: "msxml6", referred by package: "as", install will be skipped as a result. Skipped: InstallDTSAction Skipped: Action "InstallDTSAction" was not run. Information reported during analysis: No install request found for package: "dts", install will be skipped as a result. Skipped: InstallDTSAction.11 Skipped: Action "InstallDTSAction.11" was not run. Information reported during analysis: No install request found for package: "sqlsupport", referred by package: "dts", install will be skipped as a result. Skipped: InstallDTSAction.12 Skipped: Action "InstallDTSAction.12" was not run. Information reported during analysis: No install request found for package: "sqlncli", referred by package: "dts", install will be skipped as a result. Skipped: InstallDTSAction.18 Skipped: Action "InstallDTSAction.18" was not run. Information reported during analysis: No install request found for package: "owc11", referred by package: "dts", install will be skipped as a result. Skipped: InstallDTSAction.22 Skipped: Action "InstallDTSAction.22" was not run. Information reported during analysis: No install request found for package: "bcRedist", referred by package: "dts", install will be skipped as a result. Skipped: InstallDTSAction.9 Skipped: Action "InstallDTSAction.9" was not run. Information reported during analysis: No install request found for package: "msxml6", referred by package: "dts", install will be skipped as a result. Skipped: InstallNSAction Skipped: Action "InstallNSAction" was not run. Information reported during analysis: No install request found for package: "ns", install will be skipped as a result. Skipped: InstallNSAction.11 Skipped: Action "InstallNSAction.11" was not run. Information reported during analysis: No install request found for package: "sqlsupport", referred by package: "ns", install will be skipped as a result. Skipped: InstallNSAction.12 Skipped: Action "InstallNSAction.12" was not run. Information reported during analysis: No install request found for package: "sqlncli", referred by package: "ns", install will be skipped as a result. Skipped: InstallNSAction.18 Skipped: Action "InstallNSAction.18" was not run. Information reported during analysis: No install request found for package: "owc11", referred by package: "ns", install will be skipped as a result. Skipped: InstallNSAction.22 Skipped: Action "InstallNSAction.22" was not run. Information reported during analysis: No install request found for package: "bcRedist", referred by package: "ns", install will be skipped as a result. Skipped: InstallNSAction.9 Skipped: Action "InstallNSAction.9" was not run. Information reported during analysis: No install request found for package: "msxml6", referred by package: "ns", install will be skipped as a result. Skipped: InstallRSAction.11 Skipped: Action "InstallRSAction.11" was not run. Information reported during analysis: No install request found for package: "sqlsupport", referred by package: "rs", install will be skipped as a result. Skipped: InstallRSAction.18 Skipped: Action "InstallRSAction.18" was not run. Information reported during analysis: No install request found for package: "owc11", referred by package: "rs", install will be skipped as a result. Skipped: InstallRSAction.22 Skipped: Action "InstallRSAction.22" was not run. Information reported during analysis: No install request found for package: "bcRedist", referred by package: "rs", install will be skipped as a result. Running: InstallSqlAction.11 at: 2007/2/19 19:51:4 Installing: sqlsupport on target: CATCSAP021211 Complete: InstallSqlAction.11 at: 2007/2/19 19:51:5, returned true Running: InstallSqlAction.12 at: 2007/2/19 19:51:5 Installing: sqlncli on target: CATCSAP021211 Complete: InstallSqlAction.12 at: 2007/2/19 19:51:6, returned true Running: InstallSqlAction.18 at: 2007/2/19 19:51:6 Installing: owc11 on target: CATCSAP021211 Complete: InstallSqlAction.18 at: 2007/2/19 19:51:13, returned true Running: InstallSqlAction.21 at: 2007/2/19 19:51:13 Installing: sqlwriter on target: CATCSAP021211 Complete: InstallSqlAction.21 at: 2007/2/19 19:51:18, returned true Running: InstallSqlAction.22 at: 2007/2/19 19:51:18 Installing: bcRedist on target: CATCSAP021211 Complete: InstallSqlAction.22 at: 2007/2/19 19:51:28, returned true Running: InstallSqlAction.9 at: 2007/2/19 19:51:28 Installing: msxml6 on target: CATCSAP021211 Error: MsiOpenDatabase failed with 110 Failed to install package The installation source for this product is not available. Verify that the source exists and that you can access it. Error: MsiOpenDatabase failed with 110 for MSI {5A710547-B58E-488B-828D-CA9A25A0533C} Setting package return code to: 1612 Complete: InstallSqlAction.9 at: 2007/2/19 19:51:28, returned false Error: Action "InstallSqlAction.9" failed during execution. Error information reported during run: Target collection includes the local machine. Invoking installPackage() on local machine. Running: InstallToolsAction.11 at: 2007/2/19 19:51:28 Installing: sqlsupport on target: CATCSAP021211 Complete: InstallToolsAction.11 at: 2007/2/19 19:51:33, returned true Running: InstallToolsAction.12 at: 2007/2/19 19:51:33 Installing: sqlncli on target: CATCSAP021211 Complete: InstallToolsAction.12 at: 2007/2/19 19:51:34, returned true Running: InstallToolsAction.13 at: 2007/2/19 19:51:34 Installing: PPESku on target: CATCSAP021211 Complete: InstallToolsAction.13 at: 2007/2/19 19:53:48, returned true Running: InstallToolsAction.18 at: 2007/2/19 19:53:48 Installing: owc11 on target: CATCSAP021211 Complete: InstallToolsAction.18 at: 2007/2/19 19:53:51, returned true Running: InstallToolsAction.20 at: 2007/2/19 19:53:51 Installing: BOL on target: CATCSAP021211 Complete: InstallToolsAction.20 at: 2007/2/19 19:55:37, returned true Running: InstallToolsAction.22 at: 2007/2/19 19:55:37 Installing: bcRedist on target: CATCSAP021211 Complete: InstallToolsAction.22 at: 2007/2/19 19:55:40, returned true Error: Action "InstallToolsAction.9" failed during execution. Error information reported during run: Action: "InstallToolsAction.9" will be marked as failed due to the following condition: Condition "Package "9" either passed when it was last installed, or it has not been executed yet" returned false. Condition context: Prereq package will be failed due to the previous installation attempt returning: 1612 Installation of package: "msxml6" failed due to a precondition. Action "InstallSqlAction" will return false due to the following preconditions: Condition "Action: InstallSqlAction.9 has finished and failed." returned true. Installation of package: "sql" failed due to a precondition. Step "InstallSqlAction" was not able to run. Skipped: InstallNSAction.10 Skipped: Action "InstallNSAction.10" was not run. Information reported during analysis: No install request found for package: "sqlxml4", referred by package: "ns", install will be skipped as a result. Running: InstallToolsAction.10 at: 2007/2/19 19:55:40 Installing: sqlxml4 on target: CATCSAP021211 Complete: InstallToolsAction.10 at: 2007/2/19 19:55:44, returned true Skipped: RepairForBackwardsCompatRedistAction Skipped: Action "RepairForBackwardsCompatRedistAction" was not run. Information reported during analysis: Action: "RepairForBackwardsCompatRedistAction" will be skipped due to the following condition: Condition "sql was successfully upgraded." returned false. Condition context: sql failed to upgrade and so the uninstall of the upgraded product will not occur. Error: Action "UninstallForMSDE2000Action" failed during execution. Error information reported during run: Action: "UninstallForMSDE2000Action" will be marked as failed due to the following condition: Condition "sql was successfully upgraded." returned false. Condition context: sql failed to upgrade and so the uninstall of the upgraded product will not occur. Installation of package: "patchMSDE2000" failed due to a precondition. Error: Action "UninstallForSQLAction" failed during execution. Error information reported during run: Action: "UninstallForSQLAction" will be marked as failed due to the following condition: Condition "sql was successfully upgraded." returned false. Condition context: sql failed to upgrade and so the uninstall of the upgraded product will not occur. Installation of package: "patchLibertySql" failed due to a precondition. Action "InstallToolsAction" will return false due to the following preconditions: Condition "Action: InstallToolsAction.9 has finished and failed." returned true. Installation of package: "tools" failed due to a precondition. Step "InstallToolsAction" was not able to run. Skipped: InstallASAction Skipped: Action "InstallASAction" was not run. Information reported during analysis: No install request found for package: "as", install will be skipped as a result. Skipped: InstallRSAction Skipped: Action "InstallRSAction" was not run. Information reported during analysis: No install request found for package: "rs", install will be skipped as a result. Skipped: UninstallForRS2000Action Skipped: Action "UninstallForRS2000Action" was not run. Information reported during analysis: Action: "UninstallForRS2000Action" will be skipped due to the following condition: Condition "Action: InstallRSAction was skipped." returned true. Running: ReportChainingResults at: 2007/2/19 19:55:44 Error: Action "ReportChainingResults" threw an exception during execution. One or more packages failed to install. Refer to logs for error details. : 1612 Error Code: 0x8007064c (1612) Windows Error Text: The installation source for this product is not available. Verify that the source exists and that you can access it.
Source File Name: sqlchainingsqlchainingactions.cpp Compiler Timestamp: Thu Sep 1 22:23:05 2005 Function Name: sqls::ReportChainingResults::perform Source Line Number: 3097
I was having trouble with SQL server 2005 and reporting services. Finally I had to un-install and then re-install, had trouble with uninstalling initially. I couldn't use Add/Remove to remove Microsoft SQL Server 2005 until I found this command: "%ProgramFiles%Microsoft SQL Server90Setup BootstrapARPWrapper.exe" /Remove from http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=354408&SiteID=1
So I was able to remove (from what I know) all traces of SQL 2005 and its configuration tools. However when I reinstall it, I only have the configuration tools installed. Going to Start>>Microsoft SQL Server 2005 - configuration tools is all i have. Going to Add Remove Programs I can see Microsoft SQL Server 2005 along with Microsoft SQL Server Native Client.
When I use windows exploerer the only folders I see in c:Program FilesMicrosoft SQL Server are: 80, 90, InetPub, MSSQL.1, MSSQL.2, MSSQL.3
when I install SP2 everything but PRODUCT INSTANCE Database Services MSSQLSERVER
install correctly.
After that nothing changes.
My questions are; do I really have SQL Sever installed so that I can create and edit queries, reports, etc. And if I do how do I access it? It seems like something is left over telling the installer that I already have SQL already installed but not the configurations tools. So it just installs them.
Hi, I have SBS 2003 installed and have currently been working with Sharepoint. I upgraded to SQL Server 2005 using the methods described in the documentation provided on the SBS CD, which can be found here: http://go.microsoft.com/fwlink/?LinkId=60500
I followed the document step by step and the installation completed without any problems, however after installation when trying to access a website I created in Sharepoint prior to upgrading I ran into this error: "Unable to connect to database." That error led me to the following Microsoft support article: http://support.microsoft.com/kb/823287
I followed all three methods in that article to ensure that the server is running and that it is configured properly, but it didn't change a thing.
Looking in eventvwr I noticed the following:
Failure Audit: Login failed for user 'NT AUTHORITYNETWORK SERVICE'.
Followed by:
Error: #50070: Unable to connect to database
It sounds as if Network Service doens't have the appropriate permissions to access the SQL server, but I defined those permissions in the SQL Server 2005 upgrade following what the upgrade manual provided on the CD told me.
I have been fooling around with this issue for a long time now, does anyone have any ideas?
I've been using MS Office Accounting 2007 (free version) and today the application says that the database cannot be connected to. Basically, the SQL service will not start or run. Could it be due to Symatec's firewall? Please help.
Hi I have Visual Studio 2005 with SP1 installed, and I want to install the Management Studio. I tried many times installing that and I always got the same problem, which is when I try to create a database in VS I just don’t get trough as I used to. A message appears saying that I’ve to enable some estance. So to resolve the problem I saw if is everything ok with the SQL Server, which seemed to be fine, but I couldn’t start the Report service. Now I just formatted the computer and I’m afraid to happen all over again. May be the version with only the Management would be fine, I don’t know if it adds something beside of that.