Connecting To An SQL2005 Server

Jan 16, 2007

Hi

I am trying to upgrade a system from SQL 2000 to SQL2005.

I have installed the Server on a PC with Win XP SP2. Using another PC (also Win XP SP2) on the LAN I need to ODBC to the Server.

The Server is NOT the default instance.

I cannot connect via ODBC from the Client PC. This all worked fine with SQL 2000.

As a test I also tried a fresh install of SQL2005 where it was the default instance, this worked fine.

SO the problem is when you have multiple instances.

What do I have to do to sort it out?

Cheers

Eugene

View 5 Replies


ADVERTISEMENT

Problem Connecting SQL2005 Client To SQL2000 Server

Jan 22, 2008

OK, I'm stumped and could do with some help. I have a laptop running Vista (64bit) with the SQL 2005 client tools. At home, I have SQL Server 2000 running on Windows Server 2003. I cannot get the SQL 2005 to talk to the SQL Server 2000. At work, we have SQL 2000 running on NT 5.0 and it connects fine. I also have a second laptop with SQL 2000 client tools running on XP SP2 which conects fine to the SQL 2000 instance on the 2003 box.

The vista laptop talks to the 2003 server, so it's not simpy that there is no connection. Any ideas why I keep getting an error stating that the Server might not be accepting remote connections every time I try to connect the Vista machine to the SQL 2000 server? I can't connect either from the SQL management tool, nor via ODBC.

Any ideas would be much appreciated.

View 24 Replies View Related

Connecting To Sql2005 Using C#

Feb 12, 2006

Help...  I am new to C# and .net and I am trying to build a insert page with a couple of drop down controls where I pull a categoryID and subcategoryID to populate my dropdown controls from a MS sql2005 express database.  I am using a book that only shows how to build the script and access a access database and I am getting this error when trying to pull up the page:
 
 Description: An error occurred during the compilation of a resource required to service this request. Please review the following specific error details and modify your source code appropriately. Compiler Error Message: CS0246: The type or namespace name 'OleDbConnection' could not be found (are you missing a using directive or an assembly reference?)Source Error:





Line 3:
Line 4: <script runat="server" language="C#">
Line 5: OleDbConnection objConn = newOleDbConnection(
Line 6: "Server=SIMBA\NETSDK;" +
Line 7: "Database=btuniverse;" +Source File: c:Inetpubwwwroot\_addnews.aspx    Line: 5
 
Below is my code and I am not sure what the syntax needs to be when connecting to a ms sql datasource.  Thanks in advanced :)
 
MYCODE:
<%@ Page Language="C#" MasterPageFile="~/main.master" Title="Untitled Page" %>
    <script runat="server" language="C#">      OleDbConnection objConn = newOleDbConnection(        "Server=SIMBA\NETSDK;" +        "Database=btuniverse;" +        "User ID=sa;Password=password");    OleDbCommand objCmd;    OleDbDataReader objRdr;        void Page_Load() {        if (!IsPostBack) {            objConn.Open();                        objCmd = new OleDbCommand("SELECT * FROM dbo.tblNewsCategories", objConn);            objRdr = objCmd.ExecuteReader();            ddlCategory.DataSource = objRdr;            ddlCategory.DataValueField = "CategoryID";            ddlCategory.DataTextField = "CategoryName";            ddlCategory.DataBind();            objRdr.Close();                        objCmd = new OleDbCommand("SELECT * FROM dbo.tblSubCategories", objConn);            objRdr = objCmd.Executereader();            ddlSubCategory.DataSource = objRdr;            ddlSubCategory.DataValueField = "SubCategoryID";            ddlSubCategory.DataTextField = "SubCategoryName";            ddlSubCategory.DataBind();            objRdr.Close();                        objConn.Close();        }    }           
   </script>
<asp:Content ID="Content1" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server">
 
<table>    <tr>    <td align="right">Title:</td>    <td align="left"><asp:TextBox ID="txtArticleTitle" CssClass="textbox" runat="server" />    <asp:RequiredFieldValidator ID="RequiredFieldValidator1" ControlToValidate="txtArticleTitle" ErrorMessage="*" runat="server" />    <br />    </td>
    <!--- <asp:CompareValidator ID="cvArticleTitle" ControlToValidate="txtArticleTitle" Operator="DataTypeCheck" Type="String" ErrorMessage="No numbers allowed" />--->    </tr>    <tr>    <td align="right"><p>Article Category:</td><td align="left"><asp:DropDownList ID="ddlCategory" CssClass="dropdownmenu" runat="server" /></td>    </tr>    <tr>    <td align="right"><p>Article Sub Category:</td><td align="left"><asp:DropDownList ID="ddlSubCategory" runat="server" /></td>    </tr>    <tr><td align="right">News Article:</td><td align="left"><asp:TextBox ID="txtArticleDesc" CssClass="textbox" Columns="40" Rows="4" TextMode="MultiLine" runat="server" />    <asp:RequiredFieldValidator ID="rfvArticleDesc" ControlToValidate="txtArticleDesc" ErrorMessage="*" runat="server" />    </td>    </tr>    <tr>    <td>    </td>    </tr>    <tr>    <td>    </td>    </tr>    <tr>    <td>    </td>    </tr></table>
<asp:Button ID="btnSubmit" CssClass="button" runat="server" Text="Submit" /></asp:Content><asp:Content ID="Content2" ContentPlaceHolderID="ContentPlaceHolder2" Runat="Server"></asp:Content>
 

View 3 Replies View Related

Connecting Over Internal IP To Sql2005 Box

Jul 31, 2007

Hi,

I have 2 boxes, 1 webserver and 1 db server, both behind a firewall. For the past few years I have been connecting from the webserver to the db server using a public IP. I have 2 NIC's in the DB server so I now want to connect locally to reduce our companies bandwidth charges, and hopefully make things a tiny bit faster too. I'm not sure if it will make a difference, but should be interesting.

I'm having problems setting this up tho, what steps do I need to take to make sure it works properly?

When I check my DB servers IP configuration I get 2 NICs'

One configured as an external IP, the other configued as
169.xxx.xx.xxx

I am trying to connect using the 169.xxx.xx.xx Is this the correct approach? I am getting TimeOut Errors as seen below

I looked in my SQL configuration and its set to allow remote connections however, and since I was connecting over a public IP before, this seems contridicting.

Any help is much appreciated.

Thanks once again!!! :)
mike123


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)

View 3 Replies View Related

Connecting From Iis5 ASP.net2.0 To Sql2005

Jul 7, 2007

I'm trying to move an application I wrote from sql2000 to sql2005. The application is in ASP.NET and works fine using SQL2000 but when I moved the database and change the connect string the page display the message:



Cannot open database "EventTracker" requested by the login. The login failed.
Login failed for user 'NT AUTHORITYANONYMOUS LOGON'.



If I add the identify tag to the web.config file



<identity impersonate="true" username="myname" password="mypasword"/>


then page comes up and everything works. The problem is I need to have the user's credentials from internet explorer to be used against the SQL database to control access.



I added some lines of code to see if the web page was acting with the web users credientials and it is for things other than the SQL2005 connections.



The following error message shows up in the web server's application log:



Event code: 3005
Event message: An unhandled exception has occurred.
Event time: 7/6/2007 6:50:10 PM
Event time (UTC): 7/7/2007 12:50:10 AM
Event ID: c3d90a99419f49ad8d307930acb5bb71
Event sequence: 13
Event occurrence: 2
Event detail code: 0

Application information:
Application domain: /LM/W3SVC/1/Root/ComputerServices/TruckerViewer-9-128282421386484375
Trust level: Full
Application Virtual Path: /ComputerServices/TruckerViewer
Application Path: c:inetpubwwwrootComputerServicesTruckerViewer
Machine name: webserver

Process information:
Process ID: 960
Process name: aspnet_wp.exe
Account name: webserverASPNET

Exception information:
Exception type: SqlException
Exception message: Cannot open database "EventTracker" requested by the login. The login failed.
Login failed for user 'NT AUTHORITYANONYMOUS LOGON'.

Request information:
Request URL: http://serverws/ComputerServices/TruckerViewer/Counters.aspx
Request path: /ComputerServices/TruckerViewer/Counters.aspx
User host address: 10.10.17.187
User: $PCAUser4
Is authenticated: True
Authentication Type: NTLM
Thread account name: webserverASPNET

Thread information:
Thread ID: 1
Thread account name: webserverASPNET
Is impersonating: False
Stack trace: at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlInternalConnectionTds.CompleteLogin(Boolean enlistOK)
at System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance)
at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance)
at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection)
at System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options)
at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject)
at System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject)
at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject)
at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
at System.Data.SqlClient.SqlConnection.Open()
at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet)
at TruckerViewer.Counter1.Page_PreRender(Object sender, EventArgs e) in \webserverc$InetpubwwwrootComputerServicesTruckerViewerCounters.aspx.vb:line 61
at System.Web.UI.Control.OnPreRender(EventArgs e)
at System.Web.UI.Control.PreRenderRecursiveInternal()
at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)



The SQlserver's application log records two messages;



Login failed for user 'NT AUTHORITYANONYMOUS LOGON'. [CLIENT: 10.10.94.136]



and



Login succeeded for user 'NT AUTHORITYANONYMOUS LOGON'. Connection: trusted. [CLIENT: 10.10.94.136]



This exact same code works with SQL2000 but not with SQL2005. What am I missing? Any help would be appreciated.







View 5 Replies View Related

Connecting To SQL2005 Developer Edition

Jan 30, 2006

I'm attempting to connect to and instance of SQL and cannot seam to find it. The server logs says its listening on '127.0.0.1 <ipx4> 1545'.

Kind of stuck what to check next. Will using pipes help? What do I need to do?

View 1 Replies View Related

Trouble Connecting Remotely To Sql2005 From Other Machines.

Sep 20, 2007

New sql2005 install as a named instance and having trouble connecting from remote machines.

I noticed on our other servers that the "Public" server role is listed in permissions (right-click over the sqlmgr connection for the dialog, then permissions).

When I try to add the role to the new server it doesn't save! This is the only setting that's different, can't connect using sqlmgr from other machines to this server so any ideas on other settings to look at appreciated.

View 6 Replies View Related

Sql2005 Database Restore From Another Sql2005 Backup File Error.

Dec 15, 2005

hi

i try to restore a bak file from another sql2005 server to my sql2005 server, but it show the error message as below :

 

 

TITLE: Microsoft SQL Server Management Studio Express
------------------------------

An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.Express.ConnectionInfo)

------------------------------
ADDITIONAL INFORMATION:

Cannot open backup device 'C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBackupackup.bak'. Operating system error 5(error not found).
RESTORE HEADERONLY is terminating abnormally. (Microsoft SQL Server, Error: 3201)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.1399&EvtSrc=MSSQLServer&EvtID=3201&LinkId=20476

------------------------------
BUTTONS:

OK
------------------------------


 

 

 

pls some one can help me ???

 

thanks

chaus

View 62 Replies View Related

Can You Open A Database Created In SQL2005 In SQL2005 Express?

Oct 12, 2007



Can you open/use a database created in SQL2005 in SQL2005 Express?

Thanks for the help!

Max

View 4 Replies View Related

Upgraded SQL2000 To SQL2005, SQL2005 VERY Slow

Dec 27, 2005

I just upgraded my SQL 2000 server to SQL2005. I forked out all that money, and now it takes 4~5 seconds for a webpage to load. You can see for yourself. It's pathetic. When I ran SQL2000, i was getting instant results on any webpage. I can't find any tool to optimize the tables or databases. And when I used caused SQL Server to use 100% cpu and 500+MB of ram. I can't have this.Can anyone give me some tips as to why SQL 2005 is so slow?

View 3 Replies View Related

Sql2005 Standard To Sql2005 Enterprise Edition

Jan 4, 2007

Hi

We have Sql2005 x64 bit standard edition server installed in windows 2003 64 bit editio server,

currently due to buisness requirements we need to have sql2005 x64 bit enterprise edition, please let me know how do i do the upgrade or change.

is it possible to retain all our custom settings in the standard edition after changing to enterprise edition.

This has to be done for our production and very critical, please help



Thanks

Samuel I

View 4 Replies View Related

Install Sql2005 32 Bit After Removing Sql2005 64 Bit

Sep 19, 2007



I am unable to install 32-bit SQL Server Integration Services on the server due to something that was left behind by the 64-bit version.


I've uninstalled SQL Server 2005 64-bit and when I try to install the 32-bit version of Integration Services, I get this error: "Failed to install and configure assemblies C:Program Files (x86)Microsoft SQL Server90DTSTasksMicrosoft.SqlServer.MSMQTask.dll in the COM+ catalog. Error: -2146233087 Error message: Unknown error 0x80131501 Error descrition: FATAL: Could not find component 'Microsoft.SqlServer.Dts.Task.MessageQueueTask.ServCompMQTask' we just installed."




I can't seem to figure out how to resolve this problem with the COM+ and I can't remember if Integration Services is required.

Can anybody please advise?

View 1 Replies View Related

Migrating Sql2005 Vb Dts Package To Sql2005

Jul 8, 2007

Hello,



I have a vb program that include a dts package that has been saved to vb with sql2000 dts wizard and works very good.



Now that I upgrade my website to sql2005, this vb dts package doesn't work.

The error I get is:



Microsoft Data Transformation Services (DTS) Package

Invalid STDGMEDIUM structure

(Microsoft Data Transformation Services (DTS) Package (80040066): Invalid STDGMEDIUM structure

) (Microsoft SQL-DMO (ODBC SQLState: 42000) (80004005): [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near ')'.)



I searched in the internet how to make dts package in sql2005 and save it to vb and found no information about it.

What Can I do to get the vb code of the dts package I create in sql2005 or how do i migrage the sql2000 vb dts package code to sql2005?



Thanks,

Kubyustus









View 4 Replies View Related

Can't Connect To Local Server Instance MSSQLSERVER In SQL Server Management Studio (SQL2005 Sp2/Vista)

Apr 7, 2007

Can't connect to local server instance MSSQLSERVER in SQL Server Management Studio (SQL2005 sp2/Vista).



SQL Server Configuration Manager reports SQL Server2005 services: SQL Server (MSSQLSERVER) Running. This would indicate the name of the SQL server is "MSSQLSERVER" correct? I chose "default" instance during the install and that is the name it gave itself.

I tried connecting to the server using the following for the Server Name: MSSQLSERVER and .MSSQLSERVER neither works.



The only thing that works for my installation is just plain "." (no quotes) and nothing else. Can this be correct because I can't find any reference to this. Thanks.

View 1 Replies View Related

SQL2005 With No Server

Jul 29, 2006

Please What can i do with this message


"TITLE: Connect to Server
------------------------------

Cannot connect to MAhgoop.

------------------------------
ADDITIONAL INFORMATION:

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) (Microsoft SQL Server, Error: 2)

For help, click: http://go.microsoft.com/fwlink?ProdName=Mi...mp;LinkId=20476

------------------------------
BUTTONS:

OK
------------------------------
"
"

View 4 Replies View Related

MDF Files And SQL2005 Server

Jun 18, 2008

 Hi Guy's, I have 2 questions:1. When I setup roles, a aspnetdb.mdf file is created automatically. Can I use the same database for any other / new table which is needed in my solution or do I need to create a second database?2. My hosting company does not support mdf files and there is no mdf attach tool available as well. Can someone explain to me how I get the mdf database into the SQL2005 Server and is there anything I need to change afterwards (connection strings etc.)? Thanks a lot in advance

View 3 Replies View Related

SQl2005 - Linked Server

Jul 16, 2007

Help pl.


I need to access object from Oracle 9i. I've installed O9i client on sql server and create linked server to O9i db. but when executing

exec sp_tables_ex N'SUN920' ---> list of all table appear

and when selecting from a prticular table -- got below msg

Msg 7314, Level 16, State 1, Line 2
The OLE DB provider "OraOLEDB.Oracle" for linked server "sun920" does not contain the table ""shm"."x"". The table either does not exist or the current user does not have permissions on that table.

how to resolve this issue

View 2 Replies View Related

Help Tuning New Sql2005 Server

Apr 18, 2007

Hi,

I just upgraded my sql2000 server (3gb Ram,2 x2.4ghz p4xeon processors) to sql2005 64 bit (4gb ram,1 x dual core 2.0 xeon processor) The single processor is supposed to be faster than the previous dual processors combined.

The problem is now I am having major performance problems, the queries are lagging pretty badly intermittently.

What steps should I take to resolve this? I am planning on upgrading to 8gb of RAM tonight or tommorow as a 'throwing hardware at this problem without really knowing what I'm doing approach.'

I am not very good with perfmon, but if you want any stats from there please let me know. I'm googling now what I should be checking for.

I can't figure out why its actually running worse, these problems got worse after I set a maintenance plan to run last night which did backups, reindex all the stuff etc... It failed after 2 hours and I woke up to horrible performance this morning.

Any help much appreciated!


Thanks,
mike123

View 12 Replies View Related

Server Is Not A Subscriber (SQL2005)

May 17, 2006

Just setup 2 boxes w/ SQL Server 2005 (Developer Ed) (SP1)

Server A: Tablet PC running XP (publisher/distributor)

Server B: running Win2K (subscriber)

Setup replication and recv'd error: 'server B is not a subscriber'.

This error is very vague and does not offer any direction to look for a solution.

unable to locate help on a solution from online books.

thx. for your review and input to this issue..bt

View 4 Replies View Related

Can I Install SQL2005 SP2 To TFS Server?

Mar 29, 2007

Hi!

We have a TFS server include this components:

windows standard R2 server + SP1

Microsoft SQL Server 2005 + SP1

Microsoft Visual Studio 2005 Team Foundation Server - ENU + SP1

Microsoft Windows SharePoint Services 2.0.

Can I install sql 2005 SP2 without any problem?

Best Regards,

Mihaly Demeczky





View 1 Replies View Related

Can SQL2005 Run With Oracle 10g In The Same Server?

May 21, 2007

is possible install SQL 2005 into a server with Oracle 10G?

View 1 Replies View Related

Restore A Set Of Databases From A SQL2000 Server To A SQL2005 Server

Nov 3, 2006



I can restore databases one by one, setting .mdf and .ldf destination paths.

How can I restore all my Databases at the same time?

Thanks

G. Zanghi

View 7 Replies View Related

Linked Server From SQL2005 To SQL2000

Jan 7, 2007

Linked server from SQL2005 to SQL2000
Hi
I use the following SQL statements to create a link server. RemoteServerName is an SQL2000 and I am executing this in another machine which is SQL2005.
 
Though the link server is created successfully, I am not able to se the tables under it so could not query anything.
 
----
 
USE [master]
EXEC master.dbo.sp_addlinkedserver @server = N'RemoteServerNameInstanceName', @srvproduct=N'SQL Server'
EXEC master.dbo.sp_serveroption @server=N'RemoteServerNameInstanceName', @optname=N'collation compatible', @optvalue=N'false'
EXEC master.dbo.sp_serveroption @server=N'RemoteServerNameInstanceName', @optname=N'data access', @optvalue=N'true'
EXEC master.dbo.sp_serveroption @server=N'RemoteServerNameInstanceName', @optname=N'rpc',@optvalue=N'false'
EXEC master.dbo.sp_serveroption @server=N'RemoteServerNameInstanceName', @optname=N'rpc out', @optvalue=N'false'
EXEC master.dbo.sp_serveroption @server=N'RemoteServerNameInstanceName', @optname=N'connect timeout', @optvalue=N'0'
EXEC master.dbo.sp_serveroption @server=N'RemoteServerNameInstanceName', @optname=N'collation name', @optvalue=null
EXEC master.dbo.sp_serveroption @server=N'RemoteServerNameInstanceName', @optname=N'query timeout', @optvalue=N'0'
EXEC master.dbo.sp_serveroption @server=N'RemoteServerNameInstanceName', @optname=N'use remote collation', @optvalue=N'true'
EXEC master.dbo.sp_addlinkedsrvlogin @rmtsrvname = N'RemoteServerNameInstanceName', @locallogin = NULL , @useself = N'False', @rmtuser = N'remoteUser', @rmtpassword = N'remotePassword'

View 5 Replies View Related

Deploying App To 2003 Server With SQL2005

Feb 19, 2007

I devloped this app with vs2005 and SQL 2005 express, everything seems to work fine, when I deploied the app to my web server I got a few different error messages that I worked through but now stuck on this one. i am sure it is something with SQL 2005 server. is there anywhere that has a good check list for doing things right in asp and SQL deployment?
here is the error message i am getting from debugging.
The SELECT permission was denied on the object 'Categories', database 'Blog', schema 'dbo'. 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: The SELECT permission was denied on the object 'Categories', database 'Blog', schema 'dbo'.
Source Error:
Line 33:             SqlConnection connection = CreateConnection();Line 34:             SqlCommand command = CreateCommand(connection, query, parameters);Line 35:             SqlDataReader reader = command.ExecuteReader(CommandBehavior.CloseConnection);Line 36: Line 37:             Type datatype = factory.GetDataType(); 
Source File: c:InetpublogplankroadApp_CodeUtilitiesSqlDatabase.cs    Line: 35

View 1 Replies View Related

Can A SQL2005 DB Be Hosted On A SQL2000 Server ?

Jan 2, 2007

Hi,
I'd like to host a small website created using VS2005 EE with a company that offers just SQL2000 DB support.
My question, can i use the DB created by VS site manager as a DB to the site, if not, is there any alternatives.
Thanks.

View 1 Replies View Related

Updating DB Server To SQL2005 *after* The Install?

Feb 15, 2007

I had a SQL2000 Server with a simple database. I did an "in place" upgrade to SQL2005 expecting the DB Server and databases to upgrade. However, now when I run SQL Server Management Studio and enter the query:-

SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')

I get the answer:-

8.00.2039SP4Enterprise Edition

Why didn't it upgrade? And how do I upgrade it now? I'm very confused!

View 3 Replies View Related

Need To Migrate A Sql2k Server To Sql2005

Jan 17, 2008

Hi,

I have a server that has sql server 2000 standard edition, and I just got a new server but this time I'm going to use sql2005 Express (free version).

My databases are not 2gigs in size, so I should be fine.

What is the best method for me to convert the databases? Is it to just detach the database and re-attach in sql2.5?

View 4 Replies View Related

Change Server Name In SQL2005 Cluster

Jun 26, 2007

Once the SQL2005 cluster is installed can I change the "physical" server name of the 2 server nodes in the cluster. I do not want to change the virtual server name but the "physical" Windows server name....



Steve Dunn

sdunn@esiindy.com

View 1 Replies View Related

Link Server From SQL2005 To SQL2000

Jul 2, 2007

I have the follwoing scenario, where the query returns an error, when we tried to upgrade oru production SQL2000 enviroment to SQL2005.

SQL2000 Env:
Microsoft SQL Server Developer Edition
Microsoft Windows NT 5.2 (3790)
8.00.2175 SP4

SQL2005 Env:
Microsoft SQL Server Developer Edition
Microsoft Windows NT 5.2 (3790)
9.00.3054.00

Notice the removal of the two RTRIMs.


Any help welcome
Gertus


Current Connection was on the SQL2005 machine:
Remote Link Server SQL2000 SP4

Working:
SELECT * FROM Entity -- on SQL2005
WHERE
(EntityRef) + Source NOT IN
(SELECT (ENTITYID) + 'EU' FROM MRIEU.MRIOB.dbo.ENTITY) --this is on sql2000
AND Source = 'EU'

Not-working:

SELECT * FROM Entity-- on SQL2005
WHERE
RTRIM(EntityRef) + Source NOT IN
(SELECT RTRIM(ENTITYID) + 'EU' FROM MRIEU.MRIOB.dbo.ENTITY)
AND Source = 'EU'



Error :: >>

OLE DB provider "SQLNCLI" for linked server "MRIEU" returned message "Cannot create new connection because in manual or distributed transaction mode.".

Msg 7320, Level 16, State 2, Line 1

Cannot execute the query "SELECT TOP 1 1 FROM "MRIOB"."dbo"."ENTITY" "Tbl1005"" against OLE DB provider "SQLNCLI" for linked server "MRIEU".

View 2 Replies View Related

Server 2003 Sql2005 Iis6

Jan 30, 2008

Have Server2003 Enterprise running IIS6 and sql2005. Lease is up and have to migrate to new server. Any migration tools out there to make this easier? Saw one for exchange, 2000-2003, but not one to do the server2003-server2003 and/or IISy-IIS6 and SQL2005-SQL2005. Any pointers for assistance?


thanks,
Janet

View 6 Replies View Related

32-bit Dtexec Missing On X64 SQL2005 Server

Sep 18, 2007

Our production servers run Win 2003 x64. There is SQL Server 2005 x64 and Integration Services installed (both build 9.0.3175). SSIS is working between SQL Servers.
Now I have to import Excel but can't find the 32-bit version of dtexec. There is definite only the 64-bit version of dtexec installed.
Why does SSIS installation don't install the whole SSIS functionality?
What do we have to install to get the full SSIS functionality including 32-bit? We can't try and error on a running production server.

thanks
Peter

View 9 Replies View Related

Can SQL2000 &&amp; SQL2005 Co-exist On The One Server??

Sep 29, 2006

i realise you can have both SQL2000 & SQL2005 Client software co-existing on one (developement) machine.

but i cant seem to find a definitive answer on whether i can install both complete databases on a server??

we are currently building a new development server and would like to install both version on it if possible??

Cheers,
Craig

View 1 Replies View Related

Commit Transaction Between Sql2000 And Sql2005 Server

Oct 20, 2006

Are there any tips/techniques/issues when doing a begin tran and commit between a sql 2000 server/db and a sql 2005 server/db. Should you still use "set xact_abort on"? This will be a recordset of about 1-2000

View 1 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved