I see in several recommendations I found from searching for answers why we were losing the connection to the database. One of these was tweaking the Network Interface Card to ensure it is set to 1024 in the registery. Another was twaeking the TCP-IP setting for windows under
Most of these did not mentioned SQL Server 2005. I wondering if someone of more experience with SQL Server 2005 than I can address if this action is required in the newer version.
Since some analysis services features are only available in Enterprise version , I have to upgrade my SQL 2005 server from standard edition to enterpise edition.
So I uninstall originial standard version of analysis service and install a Enterprise version. However, the analysis service is still a standard version after installation.
Is it possible to keep data engine as standard version and install a enterprise version of analysis service?
We have a 64bit os machine that we accidently loaded the 32 bit version of sql server on. We now want to upgrade it to 64 bit sql server, but we now have a production database on it. My understanding is that all I have to do is detach the production database, upgrade to 64bit sql server, then reattach the database. Is this really all I have to do?
I recently installed SQL Server on a machine running Windows Server 2003. Before it was on my desktop. When I checked the TCP/IP settings under configuration manager, I noticed it doesnt have anything for my IP address. I just have a entry for the 127.0.01 loopback address. I know when I had it installed on my desktop there was a entry for my IP address. Is this ok or did something go wrong and it didnt set the IP address? I can still login and access the databases fine from Managament Studio.
Also would it better to have the services run as a network service or a local service?
So I'm in the middle of building SQL Server 2005 on my new cluster hardware. I've got all the goodies this time around -4x PowerEdge 68004x dual core x64 procs in each box32GB ram in each boxWindows Server 2k3 R2 Enterprise x64 SP2SQL 2005 Enterprise x64 SP2Active Active Active Passive cluster (4 boxes, 3 instances)dedicated data, log, and tempDB 4Gb 15k fiber channel SAN Volumes for each instanceNow, this is the first x64 box I've configured, so I'm looking for some optimization tips for a couple things.First one's memory. On our 32bit systems, I always added the /PAE switch to the boot.ini file and enable AWE in SQL Server. From what I'm reading, that's no longer needed with the enhanced memory addressing. Is that the case? Is there an MS best practices KB doc in regards to configuration? I can't find one.Also, should I set anything special pagefile-wise? I know the old mantra is 1.5x system memory, but that would create a 48GB page file. Our current cluster has 6GB of ram dedicated to each instance (2k) and Perfmon tells me it's barely touching the pagefile. I'm thinking of just leaving it default, but I want to know if there is a best practice that I'm missing. Again, I can't find an MS doc that addresses this particular scenario.
Hi, I'm installing SQL Server 2005 on windows 2003 R2. Which Collation Designator is to be used so that the both English as well as Arabic characters can be stored simultaneously...? That is "The collation settings designator which support both Arabic as well as English character set"...
We have SSRS 2005. The install put virtual directories under the website we wanted. We upgraded from Standard to Enterprise, and I put in virtual directories under the default web site so that the upgrade would work just fine. It did.
So, now I have 2 web addresses accessing the same database backend and the same files/folders on the same web server.
Someone added a mapping for .jsx extension and chose select all in the next dialog box and Reporting Services (under that web site) has not worked since. However, the one under the default web site works perfectly well. That leads me to believe that the files are fine, and the connection to the database is fine. I have tried deploying a report and it works.
The error I get from the http://server/reports interface is: Unable to connect to remote server
The error I get from the log files (ReportServerWebApp_) is: System.Net.WebException: Unable to connect to the remote server ---> System.Net.Sockets.SocketException: No connection could be made because the target machine actively refused it at System.Net.Sockets.Socket.DoConnect(EndPoint endPointSnapshot, SocketAddress socketAddress) at System.Net.Sockets.Socket.InternalConnect(EndPoint remoteEP) at System.Net.ServicePoint.ConnectSocketInternal(Boolean connectFailure, Socket s4, Socket s6, Socket& socket, IPAddress& address, ConnectSocketState state, IAsyncResult asyncResult, Int32 timeout, Exception& exception) --- End of inner exception stack trace --- at System.Net.HttpWebRequest.GetRequestStream() at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters) at Microsoft.SqlServer.ReportingServices2005.ReportingService2005.ListSecureMethods() at Microsoft.SqlServer.ReportingServices2005.RSConnection.GetSecureMethods() at Microsoft.ReportingServices.UI.Global.RSWebServiceWrapper.GetSecureMethods() at Microsoft.SqlServer.ReportingServices2005.RSConnection.IsSecureMethod(String methodname) at Microsoft.SqlServer.ReportingServices2005.RSConnection.ValidateConnection() at Microsoft.ReportingServices.UI.ReportingPage.EnsureHttpsLevel(HttpsLevel level) at Microsoft.ReportingServices.UI.ReportingPage.ReportingPage_Init(Object sender, EventArgs args) at System.EventHandler.Invoke(Object sender, EventArgs e) at System.Web.UI.Control.OnInit(EventArgs e) at System.Web.UI.Page.OnInit(EventArgs e) at System.Web.UI.Control.InitRecursive(Control namingContainer) at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) w3wp!ui!6!12/3/2007-14:52:10:: e ERROR: Exception in ShowErrorPage: System.Threading.ThreadAbortException: Thread was being aborted. at System.Threading.Thread.AbortInternal() at System.Threading.Thread.Abort(Object stateInfo) at System.Web.HttpResponse.End() at System.Web.HttpServerUtility.Transfer(String path, Boolean preserveForm) at Microsoft.ReportingServices.UI.ReportingPage.ShowErrorPage(String errMsg) at at System.Threading.Thread.AbortInternal() at System.Threading.Thread.Abort(Object stateInfo) at System.Web.HttpResponse.End() at System.Web.HttpServerUtility.Transfer(String path, Boolean preserveForm) at Microsoft.ReportingServices.UI.ReportingPage.ShowErrorPage(String errMsg)
Since it works with the same files and database on the default web site, and not on the website I want it to, I figure its an IIS setting or config problem/issue. I have looked at all the settings in the Properties for both Reports and ReportServer for both websites, but dont see a difference. I have also looked at the settings in the Properties for both web sites and while I know there are a few differences, there should be. (I did try to set them the same just to know, and it still didnt work). I have also deleted and recreated my Virtual Directories under the website I want it to work, with no success.
Anyone have any other suggestions, or links, or anything?
I'm having trouble finding the optimum memory settings for SQL Server 2005. I have 4 instances running on a macine with 8 dual-core processors and 18GB of RAM. I have tried the following memory settings so far:
No maximum - one instance used about 12GB of RAM so then the others struggled Maximum of 4GB each (2GB left for Windows) - meant that 3 instances could be using 1GB each and then another at 4GB and needing more whilst 9GB sat unused. Minimum of 2GB each - one instance would use up 10GB and then never give any back to the other instances.
I also find that setting a maximum then just causes a high amount of paging. What I would like to do is have each instance use a minimum amount, say 1GB, and then have each instance use a maximum of 13GB (3GB for other 3 instances running at a minimum level and 2GB for Windows). This 13GB should then be released and allocated to another instance when necessary, assuming it is no longer all being used. I do not want paging to occur if an instance reaches 13GB.
How do I go about configuring SQL Server to behave like this? Is it possible?
My default filter settings are: Name Schema Created How do I add an additional filter such as 'Modified'? I can get into the Filter Dialog box by clicking on the Funnel, but I can't figure out how to add another filter to the list.
It appears that when you use the import/export wizard from within Microsoft SQL Server Managment Studio, the identity attributes of the table being copied are not transferred. For example, say the source table has a column
[ref] [int] IDENTITY ( 1 , 1 ) NOT NULL,
When the import wizard is done the destination table will have a column named ref, but will not be an identity column. The column definition will be
[ref] [int] NOT NULL,
instead. Is there a way to change this behavior somewhere in the gui? When doing the import, the only options seems to be 'Enable Identity Insert', but checking this does not affect the definition of the column.
I have a developer who built an application using the SSE 2005 December CTP and I would like to bring the db's into the official SSE 2005 released version. I have attempted the following:
1. Create the db's in the released version, detach and re-attach the CTP db's. I got an error telling me they were incompatible.
2. Installed CTP version on one server, backed up the db's and then attempted to restore the db's on another server running the official released version of SSE 2005. Got an error attempting that too.
3. Installed the Management Studio for SS 2005 Developer edition thinking that I could connect to the two seperate instances of each server and like I could in EM 2000 run the transfer wizard to move the db's and data from one server to the next. Problem with this is that I can't get an object browser connection established. I have TCP/IP all config'd correctly, too.
Any other ideas where I can go with this at this time?
I installed Visual Studio 2005 Professional then after that was installed and running, I tried to install the the SQL Server 2005 Developer's Edition which installed but I do not get the SQL Server 2005 Studio Manager. I have remove and reinstalled but it never gets installed. Any ideas?
We have SQL Server 2005 Standard edition in a box. We need to update (install) that box with SQL Server Developer editions. Please let me know what are the ways to do it.
I m using Windows 2003 Server. I installed SQL Server2005 and now i want to apply CTP service pack on it. I downloaded all the SP2 patches available on the site http://www.microsoft.com/downloads/details.aspx?FamilyID=D2DA6579-D49C-4B25-8F8A-79D14145500D&displaylang=en . Each of them is giving an error and it is not getting installed on SQLServer 2005; Is it a problem with my hardware? or the version of Windows? or the version of SQLServer 2005?
We have SQL Server 2005 Standard edition in a box. We need to update (install) that box with SQL Server Developer editions. Please let me know what are the ways to do it.
I applied SQL Server 2005 SP1, everything appeared to run successfully but if I run select @@version, the version number did not update. I still see 1399 not 2047. Here is the last part of the hotfix log:
I have run exec xp_msver on the sql server management studio please can anybody tell me which edition of sql server 2005 i am using... is it ENTERPRISE EDITION or EXPRESS edition. thanks in advance regards, pranav
This will become a recommendation for my customer; we are struggling with performance on this new install which is temporarily done with the Evaluation version and I see a Service Pack has been published. Please advise?
I'm about to go absolutely nuts. I've tried so many things including:
1) Of course making sure Remote connections and both TCP/IP and named pipes are enabled for SQL 2005 2) Verified my connection string works. I even tested it in Enterprise Library using the tool and it connects successfully via windows authentication 3) Made sure of course my logged in user is a member of the administrator group and that my user in SQL 2005 logins has db_owner and full rights to the DB I am connecting to. I also made sure the NT AUTHORITY as well as the 3 sql service users have db_owner rights as well as the adminstrator in the SQL Server logins all have db_owner to the DB 4) Started the SQL Server Browser service, SQL Server DB engine, and SQL Server Agent 5) Made sure my site is setup right in IIS 7. I checked the connection string in there as well as it shows up in IIS7 in one of the sections. Using Windows authentication and it is enabled for my site 6) Tried running the .net site using both localhost (IIS) and also tried using the Visual Studio built-in web server. Both give this message still
Error Details:
Server Error in '/' Application.
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) Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.Data.SqlClient.SqlException: 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)
Source Error:
An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below. Stack Trace:
[SqlException (0x80131904): 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) +800131 System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +186 System.Data.SqlClient.TdsParser.Connect(ServerInfo serverInfo, SqlInternalConnectionTds connHandler, Boolean ignoreSniOpenTimeout, Int64 timerExpire, Boolean encrypt, Boolean trustServerCert, Boolean integratedSecurity, SqlConnection owningObject) +737554 System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, Int64 timerExpire, SqlConnection owningObject) +114 System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(String host, String newPassword, Boolean redirectedUserInstance, SqlConnection owningObject, SqlConnectionString connectionOptions, Int64 timerStart) +381 System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance) +181 System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance) +173 System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection) +357 System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options) +30 System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject) +424 System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject) +66 System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) +494 System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) +82 System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) +105 System.Data.SqlClient.SqlConnection.Open() +111 System.Web.SessionState.SqlStateConnection..ctor(SqlPartitionInfo sqlPartitionInfo) +79
Hi We have a bunch of servers running server 2000 & 2003 along with many sql server (versions 2000 & 2005) databases in a production environment pulling transactions then doing warehousing & reporting.
An audit has shown up 1 production server using English_US 'mmddyyyy' system date formats, all others being English_Australian 'ddmmyyyy'.
Is it safe to simply change the regional settings on this English_US server to English_Australian or will it mess up the data in our SQL 2005 databases? I've not been able to get a definitive answer from anyone yet!
When I installed VS 2005, it installed the default version of SQL Server 2005 Express that ships with Visual Studio 2005 installer media.
How can apply SQL Server 2005 Express SP1 to update this existing instance?
Currently, if I run this query:
SELECT @@version
I get the following:
Microsoft SQL Server 2005 - 9.00.1399.06 (Intel X86) Oct 14 2005 00:33:37 Copyright (c) 1988-2005 Microsoft Corporation Express Edition on Windows NT 5.1 (Build 2600: Service Pack 2)
After applying SP1, I should get 9.00.2047.00.
Should I just go to this link and download & install the SQL Server 2005 Express Edition SP1:
I have sql server 2005 - version 9.00.3054.00 -SP2 - Enterprise Edition. Is there any latest version than this to upgrade. I am having lot of troubles on the server these days. Whenever Analysis server cube is processed, the server is going really slow and before the cube process analysis service is stopping. I don't understand what the problem is? Analysis services is getting stopped whenever a cube is processed and server performance is getting really slower. Please let me know how to trouble shoot this.
Sorry if this is a very simple couple of questions, i've tried searching the docs but I'm not even sure which docs I should be reading!
We run a few dedicated web servers with our web host. A new one of which has sql server 2005 on it until now we've only ever used 2000.
Anyway I wanted to restore a 2000 database into 2005 and so logged into the machine for the first time, there was no management server installed just Sql Server configuration manager, fine I thought i'd be able to use SQL Express built into visual studio (2008) on my own machine. However when trying to connect I realised I didn't know the admin login details so called the host, they said there are no login details because there is no management software installed on the server and they'll install the Express version. Is this correct? Can you install SQL Server without an administrative login and you then can't connect to it until you've installed the management console?
Secondly, As I mentioned I've got SQL Express installed as part of a visual studio 2008 install, we also have a copy of SQL Server 2005 standard for internal use only, I tried to use this to install the necessary client tools and it tells me I can't because I have a higher version already installed?
Begining to wish I'd taken a look at 2005 much earlier than now as it seems like quite a big jump from 2000 in terms of management and setup...
Hi everyone I've just installed the microsoft's evaluation version of sql 2005 at my home computer. Now i'm trying to connect ("sql sever management studio") but i dont know the server's name nor user name. I dont rememeber ever asked to produce any during the installation. Bottom line- the evaluation version of sql server 2005 is installed but i cannot log in. How do i get to know my user name ? server name ? What ever i try i'm announced that the present version is not working for remote connections. I try to connect from the same very machine of the sql server. What is wrong ? Thanks
I would like to know if it's possible to embed a SQL Server 2000/2005 DBwithin a desktop application so that the end users cannot view the DB.Also, this will prevent them from copying the database on to their otherSQL Servers.Also, what are the options to load SQL Server 2005 on Win 98*** Sent via Developersdex http://www.developersdex.com ***
dim strSQL As String Dim ssceconn As New SqlCeConnection("Data Source = c:atisoftatisoft.sdf") ssceconn.Open() Dim sqlInsertRow As SqlCeCommand = ssceconn.CreateCommand()
Invalid database version. [ Db version = 0,Requested version = 0,File name = c:atisoftatisoft.sdf ]
I have Windows Vista Ultimate 64 installed on my computer, along with IIS 7 and the required IIS 6 components for SQL Server 2005. I also have Visual Studio 2005 Pro installed, but I have uninstalled SQL Server 2005 Express.
When I try to install SQL Server 2005 Pro, with all features, the 32 bit version always wants to install. I can't find a way to get the x64 version of SQL Server to install.
