Hey all...
I was using SQL2000, and liked very much the EM tool etc....
But thought that I should maybe give SQL2005 a trial, so I installed same on my box...restarted...and hey, SQL isn't running.
At least there is no icon in the tray. I have checked under Services and it looks like it's up and running....but I have NO server at all?
What did I do wrong, or what do I need to do to "start" SQL2005?
Jim
I am looking for a definitive answer to how to test if SQL2005 is installed.
I am currently checking to see if the exe exists in the MSSQ.1 folder but this fails if this instance is unintalled. Does anyone know a fullproof way of checking programically if sql2005 is installed and also where the default location of the setup exe would be located if I need to install another instance of the server. I need this in vb.net
ta
Mark
My SQL2000 databases did not upgrade to SQL2005. When I look at the Properties>>Options>>Compatibility Level the only options I have is version 7 and version 8... version 9 - which is SQL2005, is not there.
So what did I do? During the upgrade process - the installation wizard - I made a couple of choices that I believe might have lead to my current condition. The first thing is that I chose to select a installed instance. The second choice I made was to use a domain user account for the Authentication. The second selection I believe had nothing to do with the condition, but I did notice that my Systems Admin user account for SQL is no longer availble... which is a problem because now when I log into the SQL Management Console... it's using the domain name to authenticate rather than using the SA name like it was in SQL2000.
So here is what I think the solution is... I need to create a new Server Registration and create the databases in the new instance and then restore the data from SQL2000 to SQL2005 new instance, and then I can change the Compatibility Level to version 9.
The only issue I still don't have an answer for is the authentication into SQL. I want to not use the domain user account... how can I change this or can I? This also creates an issue when creating the ODBC connection as it wants to use the domain user account to verify.
So if someone can let me know if this is the right direction? Also any suggestions... i would greatly appreciate it!
John
Is sql2005 backwards compatible to provide reports for FRX? sql2000 is what the software docs ask for. Do I have to migrate and transform the data as a work around? What are the options if any?
View 1 Replies View RelatedHow can I check to be sure that the MSDE is installed properly and that it is running?
Should I be able to see the Service Manger in the tray?
Thank you,
am i going to cause problems if i install MSSQL2005 on a server with Oracle already installed and running ?
thank you
I have a question regarding Reporting Services:
I want to run the Reports on a system that has Oracle Database but reporting Services are not installed there. Only Application exe file will be there designed in .NET Windows Forms.
Reports will access oracle Database.
Hi,
I want to know whether the MSDE is already installed or not on my system using a C# program. For this I have a method which will take the service name as argument and returns whether that servce is found or not. Now I want to know which windows service (service name) will be running on my machine if the MSDE is already installed. Please help me out.
I read other threads with this problem and one solution was to install SP1 on the workstation. Our server is running 9.00.2047(SP1) and my workstation SSMS version is 9.0.2047.00 so I'm assuming it's SP1 and I am still getting this error.
To make matters worse, I have jobs set up to run these packages ON the server, but they aren't working either because I have '...error authenticating proxy...Logon failure unknown user name or bad password'. I'm trying to use my Windows login because it has sysadmin rights; I created credentials, assigned them to a proxy under SSIS Package Execution; in the SQL Agent log I get the error '...SQLServer Error: 22046, Encryption error using CryptProtectData.'.
Any suggestions appreciated.
</P
I'm having trouble running TSQL commands when SQL2005 is in single-user mode.I've restarted SQL with -m, -c, -T3608 set in the startup options.I can get into Config manager OK, but as soon as I try to start a NewQuery it complains that the DB is in single-user mode and there'salready someone connected to the DB.Is there something I need to turn off? If not, how am I supposed torun queries in single-user mode? What I want to do is move the modeland msdb databases but I can't run the commands to do this until I getpast this problem.Thanks for any assistance you can give on this.Mike
View 6 Replies View RelatedWill it be possible to do an in-place upgrade from SQL 2000 Server Enterprise SP4 32 bit running on top of 64 bit Windows 2003 Enterprise , clustered, to SQL 2005 Enterprise 64 bit?
The 32 bit SQL 2000 to 64 bit SQL 2005 in place upgrade seems questionable to me...
Anybody tried anything like this?
Is there any step by step help sites for setting up SQL 2005 linked (oracle 10) server?
I find MSDN articles but they referance winNT and 2000, I'm not getting very far and I'm not a DBA but need to get this working asap.
Hi Friends,
I have a question. At my home computer i downloaded and installed VWD. As usual it also installed Sqlexpress as part of the installation(i checked the option). Later on i downloaded Management studio separately so i am fine with my home computer as every thing is free.
But at work we decided to develop application using VS 2005 and Sqlserver 2005. So we bought and installed VS2005 professional edition at work and it also installed Sqlexpress during the installation as a defualt desktop engine. I am fine with that too. But i am not understing where do i get the Management studio? Is it some thing i could get it off the web for free or what? I am not sure we would have an option while installing the VS 2005 professional that also does install management studio and we need to check that option. I am not sure if we could get the management studion off the web for free and and evelop applications.
Please advise. Thanks -L
I want to find whether SQL Server 2005 x86 is installed or SQL Server 2005 x64 is installed programatically(Any API would do.) If anyone can recommend a registry key that I can rely on find whether it is a 32 bit or 64 bit SQL Server that would suffice.
View 5 Replies View Relatedhi
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
Can you open/use a database created in SQL2005 in SQL2005 Express?
Thanks for the help!
Max
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 RelatedHi
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
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?
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
I have some production boxes on Win 2000 32-bits OS and some production servers have been upgraded to Win2003 64-bit OS runing SQL Server 2005. There are also a number of Win2003 32-bit OS running SQL 2005.
The issue is that when linking the 64-bit production servers to the 32-bit boxes running SQL 2005 / Win 2003 OS, the linking seems to succeed, but I am unable to see a number of entries in sys.objects. Typically, these objects are User Stored Procedures.
Moreover, the linking seemed to have worked, but data extraction does not take place between the servers. However, there are no errors. The objects (user stored procs) exist on the 64-bit side, but linking does not actually happen.
Microsoft KB has addressed this in SQL 2000 case in this KB article, but has not suggested a solution for SQL 2005.
Any ideas? Has anyone else encountered this?
Thanks.
In my environment, there is maintenance plan configured on one of the server and while running DBCC checkdb on a database of size around 200GB, log file usage of tempdb is increasing and causing the maintenance job to fail.
What can I do to make the maintenance job run successfully, size of the tempdb database is only 50GB and recovery model is set to simple. It cannot be increased as the mount point on which it is residing is 50GB.
If I start a long running query running on a background thread is there a way to abort the query so that it does not continue running on SQL server?
The query would be running on SQL Server 2005 from a Windows form application using the Background worker component. So the query would have been started from the background workers DoWork event using ado.net. If the user clicks an abort button in the UI I would want the query to die so that it does not continue to use sql server resources.
Is there a way to do this?
Thanks
One of my stored procs, taking one parameter, is running about 2+ minutes. But if I run the same script in the stored proc with the same parameter hardcoded, the query only runs in a couple of seconds. The execution plans are different as well. Any reason why this could happen? TIA.
View 6 Replies View RelatedHi,
I'm just wondering how many people have gone to SQL 7 SP3.
Is it a case of only applying it if it fixes a particular problem you are experiencing, or have you installed it to keep with the latest version ?
Please let me have your thoughts (I'm currently running SP2).
Regards,
Tim
Hey all,
How do I install a SQL Server 2005 Express to have no instance?
I have a SQL 2005 Server Enterprise which has no instance, just the server name, even when pointing to the DB, you just use the server name and the DB name.
I am not any good in SQL, but need to configure SQL Express for a project I am busy with and would like it if I could only have a name, and not an instance.
hi friends,
in my system, just client tools were installed.i'm able to register to the other servers.but it is anot accepting to register my system. is there any thing to do?
How can you find out if Service Pack 1 (SP1) has been installed already or not?
- - - -
- Will -
- - - -
http://www.strohlsitedesign.com
http://www.servicerank.com/
I'm running Sharepoint server and Visual Studio on Windows server 2003. Sharepoint has its sql (officeServer) and Visual Studio installed sql express when it was installed. I can't connect to either one in VS or anywhere else. I wanted to install the adventureWorks sql database, so as to do SDK samples, and that didn't work either. I really don't understand what's going on with sql and how to use it. I can see both are running in the SQL configuration manager. Can anyone help?
View 1 Replies View RelatedHi-
I had previously had VS2005 Beta installed from my MSDN discs. When it expired, I uninstalled it and downloaded VWD Express to install. VWD installed fine, but the SQL Server Express will not install. The VWD install package doesn't give me any feedback, just says it failed. I tried dowloading and installing SQL Express separately, and it tells me that I have to uninstall all components from other versions. I have done that, but still wont install. If I use the uninstall utility on the website, it tells me it can't find any components, and all of the components listed in the manual uninstall instructions are missing, so I can't find anything further to uninstall. (FYI: I'm running XP Pro SP2).
I'm wondering if a registry setting or something didn't get updated on uninstall. I see a registry folder for "Microsoft SQL Server" but I do not know if this could be getting in the way.
Any help would be appreciated.
-Moz
Hi,
I am wondering how I can check which type of SQL Server 7 I have installed. (ie Standard/Enterprise etc) If I use @@version the following is returned:
Microsoft SQL Server 7.00 - 7.00.699 (Intel X86)
I know that the service pack number is incorporated into the version number above but I want to know the type of server I have running.
Any ideas on how I can get this information?
Cheers
Jan
I'm unable to install SQL Server 7 on Windows NT with SP5. I get
this error message:
Based on your selections setup has determined the following system
requirements are not met. Exit setup and install the missing requirements
from the CD or change your selections.
Windows NT 4.0 Service Pack 4 - needs to be reinstalled
Does anyone know how I would go about getting the MS SQL Server agent to show up as a service ? For some reason it does not show up on my Server as a service even though SQL Server 2000 is installed on that server.
View 3 Replies View Related