MS SQL uses 100% of my 2 CPU machine

Hello,

I just installed MS SQL 2000 Enterprise on a Windows 2000 Server machine
with 2 CPU's. After starting the MS SQL takes 2 x 100% of all CPU power.
I do NOT load the DB in any way with queries. Obviously this leads to
all kinds of software not working well anymore. Does anyone know how to
lower the CPU power used? Please help!?

regards,

Pierre Verbakel
The NetherlandsUnder the server properties in EM (right-click server name), under the
processor tab you can control the priority (to some degree), also you
can control how many processors SQL Server uses. I had a similar
problem with memory on an older server with only one processor. SQL
Server is notorious for being a memory hog regardless of how many
queries or users are on the system. For more of the advanced control
options related to memory tweaking and usage you need the high-end
versions of NT server and SQL Server. Although, I think that most low
to mid-size companies get by with the Standard Edition. I recommend
running only SQL Server on the server, not mixing other products like
IIS or or other applications.

HTH

P Verbakel <p.verbakel3@.chello.nl> wrote in message news:<3EFC0E13.5010809@.chello.nl>...
> Hello,
> I just installed MS SQL 2000 Enterprise on a Windows 2000 Server machine
> with 2 CPU's. After starting the MS SQL takes 2 x 100% of all CPU power.
> I do NOT load the DB in any way with queries. Obviously this leads to
> all kinds of software not working well anymore. Does anyone know how to
> lower the CPU power used? Please help!?
> regards,
> Pierre Verbakel
> The Netherlands|||If you have 100% CPU use on a fresh install, one possible reason is
the SQL Slammer worm. You don't mention if you've installed any
servicepacks, but if not, then you should update your installation as
a first step. If that resolves your issue, and you suspect that
Slammer is the cause, then you should investigate other MSSQL
installations on your network (including MSDE) to see if they are
infected - Microsoft has some tools to help.

But if you have everything already patched and up to date, then
perhaps you can give some more information about the server? In
particular, does it have other applications installed, or is it
dedicated to MSSQL? Do you have an antivirus scanner on the server
that might be continuously scanning the DB files?

Simon

P Verbakel <p.verbakel3@.chello.nl> wrote in message news:<3EFC0E13.5010809@.chello.nl>...
> Hello,
> I just installed MS SQL 2000 Enterprise on a Windows 2000 Server machine
> with 2 CPU's. After starting the MS SQL takes 2 x 100% of all CPU power.
> I do NOT load the DB in any way with queries. Obviously this leads to
> all kinds of software not working well anymore. Does anyone know how to
> lower the CPU power used? Please help!?
> regards,
> Pierre Verbakel
> The Netherlands|||It is really very easy.

1. Startup Enterprise Manager
2. Right click the machine that is running SQL and select the
properties menu option
3. Select the memory tab. I would probably recommend still using the
dynamic option but set a maximum

MS SQL Update Error

I have a database on a MSSQL Server 7 running on a Windows NT machine. This database works the last 4years with no problem. The database file is now 3 GB with 45 users. The last two months every single day an update error on a specific Table occurs. I cannot update a record in this table, and after this error occurs more than 100 records or more seemed to be locked. While I cannot edit the previous records I can create a new one with no problem. I have this problem once every sigle working day (ant the currious thing is that is occured from 8 to 10 in the morning every singke working day) . The table seems to work again after some hours or after one single day, or after I stop and start again the sql server service. Some times I have to wait some hours in order to manage to edit records in this table again. (I edit the records by using a program created with Microsoft Access and ODBC. When the error occurs I cannot edit the records neither by Access not by SQL Server Query Analyser).
This error doesn't occur when entering a new record, and might occur when only one user works with the specific Table. This table has 75 fields and about 70000 records. This table is the master of a table which has more than 200 fields and more than 750000 records. In the detail table I have no problems.
Similar problems not in this degree exist on a second database installation with about 25 users with the same table but running under a Windows 2000 Server machine.

Well when the problem appearead again I tried to edit the locked records by using Access ODBC, Access (adp project), Delphi with ADO-OLEDB and Delphi with native SQL drivers. The result was the same. A Timeout expired message appear. In the application log file of the MS SQLserver machine every time the the update error appears I get the following message: Could not Set Up Listen on Connection '1433'. Operating system Error 10049.

Any ideas??

Best regards,
Manolis PerrakisCan you supply the wording of the update error?

Also, since it tends to happen from 8-10 most mornings, you can check for blocking problems by running sp_who2 in Query Analyzer. If there are numbers in the "BlkBy" column, you have problems. Hopefully you will be able to figure out the blocker by the program- or host-name in the output of sp_who2.|||I don't have a solution for you. But I have experienced more than my share of timeouts and there's one thing I've learned: it's never what it says it is. But it seems to happen more the larger the number of elements there are in an index, and less on more normal databases. And we suspect it may be related to our use of EIDE drives instead of SCSI.

And I strongly suspect it has something to do with resources. For example: If you execute an update query causing SQL Server to execute a series of subqueries, and one of them hits a resource ceiling, one of the others with time out waiting for a thread to finish. The thread never finishes, because it's waiting for resources to be freed before it can continue. This happens all the time on our 1 GHZ server with 1GB of RAM.

I suggest you check all your indexes and make sure they're not clustered. Also, make sure you're not using too many connections if you can avoid it. And if you have too many tables that aren't normalized, try to fix that as well. Finally, you can do what I'm planning to do: change to MySql server or something else. IMNSHO, Sql Server isn't as robust as it could be.

I hope this helps.|||One other thing...Port 1433 is where SQL Server listens for connection requests. You're not opening the database everytime you do an update, are you?|||Thanks for the suggestions. My server is a Compaq ML350 with 3 SCSII hards disks and a Raid Controller, and about 600 MB RAM. I can see from the task manager that it uses all the resources. I might increase the RAM memory and in the next months I might get a new server.

Please tell me if there is a serious problem the fact that I also store in this server about 10000 photos with sizes about 2 GB, that are displayed as product pictures in the database program I've created.

I also have to mention that I use a lot of subqueries in the MSAccess program I use right now.

As far the connections issues, since I now use MSAccess for the clients, each table that is connected (attached) to the MSSQL Server holds internally its connection properies (datasource name, database name, username etc..), and since that I have about 200 tables attached from the SQL Server, this might create a connection problem.

I'm currently moving to Delphi 7, which has a global connection for all the tables of the same server. In this version the subqueries are replaced with optimised queries, and client datasets will be used in order to decrease the server load.

Best Regards,
Manolis Perrakis|||The data I store in image fields is usually quite a bit less than yours, but I don't think that's a problem. But I'm pretty sure the RAM is. You can improve things somewhat by making sure your logfile is on a different disk drive than the database, if you haven't done so already.

Try to get away from holding tables open where you can. Also, if you have a lot of indices on the master table, or a high number of values in the master index, I know from experience that can cause problems. Those problems can be alleviated by adding more RAM, further normalizing your database to reduce the number of keys (if that's possible), or looking at ways to reduce the amount of index storage--making sure you're not using clustered indexes, making sure that you're not using full-text indexing if you don't need it.

But I'm also wondering whether it's the bound controls that are the problem. At 8:00 is when everyone comes into work and launches the app, right? And by 10:00, app use drops down to a manageable level? Tables linked to app forms are almost always in Dynamic mode and I'm assuming that's the case here. If you were to modify your app so that the most common screens were read (releasing the recordset and holding the data in memory), and perform updates as that data was written (creating a new recordset for writing), you'd probably reduce the load on Sql Server significantly.

Not that any of this presents a panacea. I've spent the majority of my bugchasing over the past couple of years on problems with SQL Server/ADO. If I had any time at all, I would switch like a Tareyton smoker. :) But I think this problem can be solved.

MS SQL Update Error

I have a database on a MSSQL Server 7 running on a Windows NT machine. This database works the last 4years with no problem. The database file is now 3 GB. The last two months every single day an update error on a specific Table occurs. I cannot update a record in this table, and after this error occurs more than 100 records or more seemed to be locked. While I cannot edit the previous records I can create a new one with no problem. I have this problem once every sigle working day (ant the currious thing is that is occured from 8 to 10 in the morning every singke working day) . The table seems to work again after some hours or after one single day, or after I stop and start again the sql server service. Some times I have to wait some hours in order to manage to edit records in this table again. (I edit the records by using a program created with Microsoft Access and ODBC. When the error occurs I cannot edit the records neither by Access not by SQL Server Query Analyser).
This error doesn't occur when entering a new record, and might occur when only one user works with the specific Table. This table has 75 fields and about 70000 records.
Similar problems not in this degree exist on a second database installation with about 25 users with the same table but running under a Windows 2000 Server machine.
Any ideas??

Best Regards,
Manolis Perrakis
manolo_perrakis@.mail.grDoes the error occur when you try to edit the records using ONLY query analyzer?

Are you using an MS Access mdb file to edit the data, or are you using a Microsoft Access Data Project (ADP) file?

blindman|||Does the error occur when you try to edit the records using ONLY query analyzer?

Are you using an MS Access mdb file to edit the data, or are you using a Microsoft Access Data Project (ADP) file?

The error occurs both with Access (I'm using an mdb file connected with ODBC with SQL Server) and with the Query Analyser. When this error occurs I cannot edit this table from any computer in the network.
Therefore I'm trying to edit the table using ODBC. I haven't tried by using an ADP project, or by using another program like Delphi which uses another connection method like OLE DB.|||when you get to the point when "this" error occurrs again, can you switch to query analyzer and write an update query for a specific record?
after you get "that" error in query analyzer, paste it here. i suspect you can also get this error from sql server errorlog by double-clicking on the entry with the error. i suspect the error you're getting is referencing the total record length. if this is the case you'll need to either shrink a couple of fields or split the table into two to allow for all your fields to be updateable. to do that seemlessly for the front-end you'll have to write a view and reference this view in your inserts, updates, deletes, and selects.

MS SQL SERVER 2005 SSL ISSUE

Hi Friends,
I would be highly grateful if anyone can provide a solution for the
following :
There is a MS-SQL server hosted on a machine which is our data server.
We need to access this data server through many client machines. To
secure the data exchange between client(s) & Data server we use
JSECURE Client for SSL communication. But this secures the channel
between client machine and the machine on which my MS -SQL server
is hosted. Once the data is received on server machine, JSECURE
decrypts the data and sends to the data server. Now if I enable the
SSL
on MS-SQL server , I guess my communication would fail because I
don't
know which algorithms are being used by MS-SQL server & JSECURE
to encrypt their respective data's. So , in this case I need a bridge
between
these two ( Precisely a TRANSLATOR which understands both - JSECURE
& MS-SQL SERVERS).
Please let me know if any such solution exists. Thanks a lot to you
all friends!!Move the file share which the JSECURE connects to, to another machine.
--
Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration /
Microsoft Office SharePoint Server 2007: Configuration)
MCITP (dbadmin, dbdev)
"Phoenix" wrote:

> Hi Friends,
> I would be highly grateful if anyone can provide a solution for the
> following :
> There is a MS-SQL server hosted on a machine which is our data server.
> We need to access this data server through many client machines. To
> secure the data exchange between client(s) & Data server we use
> JSECURE Client for SSL communication. But this secures the channel
> between client machine and the machine on which my MS -SQL server
> is hosted. Once the data is received on server machine, JSECURE
> decrypts the data and sends to the data server. Now if I enable the
> SSL
> on MS-SQL server , I guess my communication would fail because I
> don't
> know which algorithms are being used by MS-SQL server & JSECURE
> to encrypt their respective data's. So , in this case I need a bridge
> between
> these two ( Precisely a TRANSLATOR which understands both - JSECURE
> & MS-SQL SERVERS).
> Please let me know if any such solution exists. Thanks a lot to you
> all friends!!
>|||Hi Denny ,
Thanksa lot for the response , being a newbie in this area I was unable to
understand your short comment , kindly elaborate a little whenever you
get some time. Also please have a look on my another post with subject
line as "PROBLEM WITH ENABLE SECURITY OPTION ON MS-SQL SERVER 2005" in this
forum.
Thanks & Regards,
Sudhansu Tiwari
"mrdenny" wrote:
[vbcol=seagreen]
> Move the file share which the JSECURE connects to, to another machine.
> --
> Denny
> MCSA (2003) / MCDBA (SQL 2000)
> MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration
/
> Microsoft Office SharePoint Server 2007: Configuration)
> MCITP (dbadmin, dbdev)
>
> "Phoenix" wrote:
>|||Since the JSECURE software encrytps all communication from the clients to th
e
server, the easiest method to resolving this issue will be to setup a server
specifically for the purpose of being the JSECURE file server. This will
allow database connections to occure normally.
You can also call the company which made JSECURE and ask them if they have a
way to make it work with Microsoft SQL Server hosted on the same server.
--
Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration /
Microsoft Office SharePoint Server 2007: Configuration)
MCITP (dbadmin, dbdev)
"Sudhansu" wrote:
[vbcol=seagreen]
> Hi Denny ,
> Thanksa lot for the response , being a newbie in this area I was unable to
> understand your short comment , kindly elaborate a little whenever you
> get some time. Also please have a look on my another post with subject
> line as "PROBLEM WITH ENABLE SECURITY OPTION ON MS-SQL SERVER 2005" in thi
s
> forum.
> Thanks & Regards,
> Sudhansu Tiwari
> "mrdenny" wrote:
>

ms sql server 2005 on my vista machine

Trying to set up a syn connection with my ipaq travel companion but

it syncs to sql server instead of to outlook.

If I uninstall sql server 2005, will it be missed by any other processes, etc.

on Vista and have it again do something ugly.

Thanks,

Bob

Vista does not require sql2k5 to run. However, if it's pre-installed, there must be a need for it by one of your third party app. If you installed it yourself and it's for fun/dev, you can safely remove/uninstall it.

MS SQL server & Sybase interoperability

Dear all,
I have an application build on Sybase database, and we waant to install MS
SQL 2000 on the same machine for a different apppliction, is there any
interoperablity issues or will the sybase application be affected by any
means.
Please advice
Thanks in advanc,
SuadDon't think so but you can use VMWare to separate out the instance.
"s.isa" <s.isa@.lycos.com> wrote in message
news:OFm%23%23$aNEHA.2876@.TK2MSFTNGP09.phx.gbl...
> Dear all,
> I have an application build on Sybase database, and we waant to install MS
> SQL 2000 on the same machine for a different apppliction, is there any
> interoperablity issues or will the sybase application be affected by any
> means.
> Please advice
> Thanks in advanc,
> Suad
>|||s.isa schrieb:
> Dear all,
> I have an application build on Sybase database, and we waant to install MS
> SQL 2000 on the same machine for a different apppliction, is there any
> interoperablity issues or will the sybase application be affected by any
> means.
> Please advice
> Thanks in advanc,
> Suad
>
We are using Sybase ASA and SQL Server 2000 on the same machine.
Installing SQL Server 2000 AFTER installing Sybase (8.0) did not cause
any problems. Both are working fine.
But installing Sybase ASA 8.0 after installation of SQL Server 2000
caused problems with the ODBC dlls. We had to exchange the ODBC32.dll to
get the SQL Server work again. Obviously Sybase overwrites these dlls
but SQL Server needs them.
Olli

MS SQL server & Sybase interoperability

Dear all,
I have an application build on Sybase database, and we waant to install MS
SQL 2000 on the same machine for a different apppliction, is there any
interoperablity issues or will the sybase application be affected by any
means.
Please advice
Thanks in advanc,
SuadDon't think so but you can use VMWare to separate out the instance.
"s.isa" <s.isa@.lycos.com> wrote in message
news:OFm%23%23$aNEHA.2876@.TK2MSFTNGP09.phx.gbl...
> Dear all,
> I have an application build on Sybase database, and we waant to install MS
> SQL 2000 on the same machine for a different apppliction, is there any
> interoperablity issues or will the sybase application be affected by any
> means.
> Please advice
> Thanks in advanc,
> Suad
>|||s.isa schrieb:

> Dear all,
> I have an application build on Sybase database, and we waant to install MS
> SQL 2000 on the same machine for a different apppliction, is there any
> interoperablity issues or will the sybase application be affected by any
> means.
> Please advice
> Thanks in advanc,
> Suad
>
We are using Sybase ASA and SQL Server 2000 on the same machine.
Installing SQL Server 2000 AFTER installing Sybase (8.0) did not cause
any problems. Both are working fine.
But installing Sybase ASA 8.0 after installation of SQL Server 2000
caused problems with the ODBC dlls. We had to exchange the ODBC32.dll to
get the SQL Server work again. Obviously Sybase overwrites these dlls
but SQL Server needs them.
Olli

MS SQL server & Sybase interoperability

Dear all,
I have an application build on Sybase database, and we waant to install MS
SQL 2000 on the same machine for a different apppliction, is there any
interoperablity issues or will the sybase application be affected by any
means.
Please advice
Thanks in advanc,
Suad
Don't think so but you can use VMWare to separate out the instance.
"s.isa" <s.isa@.lycos.com> wrote in message
news:OFm%23%23$aNEHA.2876@.TK2MSFTNGP09.phx.gbl...
> Dear all,
> I have an application build on Sybase database, and we waant to install MS
> SQL 2000 on the same machine for a different apppliction, is there any
> interoperablity issues or will the sybase application be affected by any
> means.
> Please advice
> Thanks in advanc,
> Suad
>
|||s.isa schrieb:

> Dear all,
> I have an application build on Sybase database, and we waant to install MS
> SQL 2000 on the same machine for a different apppliction, is there any
> interoperablity issues or will the sybase application be affected by any
> means.
> Please advice
> Thanks in advanc,
> Suad
>
We are using Sybase ASA and SQL Server 2000 on the same machine.
Installing SQL Server 2000 AFTER installing Sybase (8.0) did not cause
any problems. Both are working fine.
But installing Sybase ASA 8.0 after installation of SQL Server 2000
caused problems with the ODBC dlls. We had to exchange the ODBC32.dll to
get the SQL Server work again. Obviously Sybase overwrites these dlls
but SQL Server needs them.
Olli

MS SQL restore

I have a MS SQL database backup from a client and would like to use this to create the database on my local machine.

I have been advised to do this by using restore database in enterprise manager.

I am lost though as I really dont know much about MS SQL - sorry people but can anyone tell me how to do this?Sure (http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_bkprst_20h1.asp).

-PatP|||I think they had the database on their D:/ drive and I only have a C: drive

That is whats causing the problem I think.

Any suggestions on how to get round this?

Thanks

Paul|||When restoring in EM, click on Options tab and change the path for every device there.|||and buy a copy of this book...
Inside SQL Server 2000 By Kalen Delaney (http://www.bestwebbuys.com/Inside_Microsoft_SQL_Server_2000-ISBN_0735609985.html?isrc=b-search)

MS SQL Reporting Service in Windows 2003 Server

Hi,

I tried to Develop one Report in SQL Reporting Service. I have
installed SQL Reporting Serivice in Windows 2003 machine. SQL Server
Database is in another machine, running on Windows 2000. I developed
and deployed the report and all went fine.

When I tried to see the report through the Report Service Manager Web
Page it is comming properly. But When I tried to See the report in
another web page, I'm not able to see the images. But the Data is
getting Displayed and only Image is not comming. When I exported the
report to Excel, the Image is comming over there.

I am using Report Viewer control (Which came as Sample Program) in
the ASPX Page to render the report. I'm using SQL Server 2000 with SP3a
and SQL Server 2000 reporting Service with SP1.

I tried setting the Mime Time for the GIF image and even "*.*" in
the Mime Type settings of IIS 6.0. Even then its not displaying the
image.

Can any one help me out in solving the problem?

Thanks in Advance.

With Regds
KrishRS sp2 is an option. There have been a lot of fixes, but I can't tell if
this specific one was in it.

Regards
----------
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland

IM: mike@.epprecht.net

MVP Program: http://www.microsoft.com/mvp

Blog: http://www.msmvps.com/epprecht/

"Krish" <jmkrish@.gmail.com> wrote in message
news:1122361416.772274.179410@.g14g2000cwa.googlegr oups.com...
> Hi,
> I tried to Develop one Report in SQL Reporting Service. I have
> installed SQL Reporting Serivice in Windows 2003 machine. SQL Server
> Database is in another machine, running on Windows 2000. I developed
> and deployed the report and all went fine.
> When I tried to see the report through the Report Service Manager Web
> Page it is comming properly. But When I tried to See the report in
> another web page, I'm not able to see the images. But the Data is
> getting Displayed and only Image is not comming. When I exported the
> report to Excel, the Image is comming over there.
> I am using Report Viewer control (Which came as Sample Program) in
> the ASPX Page to render the report. I'm using SQL Server 2000 with SP3a
> and SQL Server 2000 reporting Service with SP1.
> I tried setting the Mime Time for the GIF image and even "*.*" in
> the Mime Type settings of IIS 6.0. Even then its not displaying the
> image.
> Can any one help me out in solving the problem?
> Thanks in Advance.
> With Regds
> Krish

MS SQL database Transfer

How can I transfer an online MS SQL Database with all data to a local machine MS SQL server. I am using Import Export Tool provided by MS SQL Enterprise manager but the referential integraity breaks (Primary and secondary key relationship). Thus the Data concurrency is lost and the database becaomes of no us.

Most of our database projects have Stored procs, Views, Triggers and contain data. Sometimes we have to take back up of the running database.

The same problem comes when we try to install an offline database with data online. We have to run the scripts through Query Analyser on the online server to install database tables, procs, triggers etc and then repopulate the database once again.

But if you see mySQL one can import the complete database with all data using phpmyAdmin tool. Most hosts provide this tool so becomes easier.

Though MS SQL has a database restoration option but 90% hosts do not allow you to automatically generate back up and download. You have to request them and then they generate the backup and upload to web server folder for us to download and restore.

Can anyone explain a solution to this daily problem..axaya

This is the DTS import/export wizard. Have you tried the "Copy objects and data Between SQL Server databases" option ?? This should copy all objects when doing the export. this copied all constraints, indexes...

Hope that helps :-)|||Any other way. DTS takes huge time and connection fails.|||How about detaching and attaching the DB, check out the link.

http://support.microsoft.com/kb/224071/

MS SQL and Sybase SQL conflict

has anyone had sucess in troubleshooting conflicts between these two?
I need to shut down the sybase client on a machine that is running MS SQL if thats possible.They generally co-exist rather peacefully once you get them settled down. The newcomer always seems to ruffle the feathers of the established resident on any given machine, but they can learn to live in peace in most circumstances.

What kind of problems are you having?

-PatP|||We're trying to install MS SQL on a machine that only has the Sybase SQL client (not the server) and it throws an error during the MS SQL install saying that it cannot find odbcbcp.dll.

So i'm wondering if shutting down the Sybase SQL client will make that dll file available/usable.|||BCP is one of few facilities common to both engines. Make sure that any Sybase-related services are shut down before you start the install.

MS SQL 2005 Management Studio

Where do I find the Management Studio to install on my laptop?
I've just installed MS SQL 2005 on a SBS 2003 machine in the office, and it
says I cannot use regular old EM to register the server on my laptop.Apparently there are more people having the same problem. Microsoft should
address this issue in a KB.
Thanks
Matt
"Steve Z" wrote:

> Where do I find the Management Studio to install on my laptop?
> I've just installed MS SQL 2005 on a SBS 2003 machine in the office, and i
t
> says I cannot use regular old EM to register the server on my laptop.|||Well - I found it...
Just like in the old version, it's installed from the same CD (actually
DVD!) that the server is installed from.
The difference, and what stopped me from going forward, was the I had to go
truly far into the install process - even putting in the product-key - to ge
t
to a selection list that allowed only the CLIENT TOOLS.
On a laptop that's already running MS SQL 2000 developers edition - that was
a big leap to take - possibly installed MS SQL 2005 on the laptop - which I
did not want to do.
The readme and help files are pretty vague in this area.
But at any rate - I've got it installed now on the laptop and it can see the
MS SQL 2005 server on the network and can even see my laptop instance runnin
g
MS SQL 2000.
Now I get to play!
"Matt" wrote:
[vbcol=seagreen]
> Apparently there are more people having the same problem. Microsoft should
> address this issue in a KB.
> Thanks
> Matt
> "Steve Z" wrote:
>|||Which Server do you mean? SBS or SQL? We have only 1 CD for SQL Server 2005
Standard. Any help is appreciated.
"Steve Z" wrote:
[vbcol=seagreen]
> Well - I found it...
> Just like in the old version, it's installed from the same CD (actually
> DVD!) that the server is installed from.
> The difference, and what stopped me from going forward, was the I had to g
o
> truly far into the install process - even putting in the product-key - to
get
> to a selection list that allowed only the CLIENT TOOLS.
> On a laptop that's already running MS SQL 2000 developers edition - that w
as
> a big leap to take - possibly installed MS SQL 2005 on the laptop - which
I
> did not want to do.
> The readme and help files are pretty vague in this area.
> But at any rate - I've got it installed now on the laptop and it can see t
he
> MS SQL 2005 server on the network and can even see my laptop instance runn
ing
> MS SQL 2000.
> Now I get to play!
> "Matt" wrote:
>|||I mean that the CLIENT TOOLS are installed from the same CD (in our case it'
s
actually a DVD from MS) that the SQL SERVER is installed from. That is the
same way the old SQL 2000 installed work.
The difference that struck me was that you were told early on in the install
process with SQL 2000 that the CLIENT TOOLS were only available (as the
machine is a workstation!).
With the SQL 2005 install CD you go through many steps, including the
licence-key (not required with SQL 2000 client install).
This appears that you are installing SQL SERVER on the workstation, but you
finally get to a selection screen where you just check off client tools...
"Matt" wrote:
[vbcol=seagreen]
> Which Server do you mean? SBS or SQL? We have only 1 CD for SQL Server 200
5
> Standard. Any help is appreciated.
> "Steve Z" wrote:
>

MS SQL 2005 Management Studio

Where do I find the Management Studio to install on my laptop?
I've just installed MS SQL 2005 on a SBS 2003 machine in the office, and it
says I cannot use regular old EM to register the server on my laptop.Apparently there are more people having the same problem. Microsoft should
address this issue in a KB.
Thanks
Matt
"Steve Z" wrote:
> Where do I find the Management Studio to install on my laptop?
> I've just installed MS SQL 2005 on a SBS 2003 machine in the office, and it
> says I cannot use regular old EM to register the server on my laptop.|||Well - I found it...
Just like in the old version, it's installed from the same CD (actually
DVD!) that the server is installed from.
The difference, and what stopped me from going forward, was the I had to go
truly far into the install process - even putting in the product-key - to get
to a selection list that allowed only the CLIENT TOOLS.
On a laptop that's already running MS SQL 2000 developers edition - that was
a big leap to take - possibly installed MS SQL 2005 on the laptop - which I
did not want to do.
The readme and help files are pretty vague in this area.
But at any rate - I've got it installed now on the laptop and it can see the
MS SQL 2005 server on the network and can even see my laptop instance running
MS SQL 2000.
Now I get to play!
"Matt" wrote:
> Apparently there are more people having the same problem. Microsoft should
> address this issue in a KB.
> Thanks
> Matt
> "Steve Z" wrote:
> > Where do I find the Management Studio to install on my laptop?
> >
> > I've just installed MS SQL 2005 on a SBS 2003 machine in the office, and it
> > says I cannot use regular old EM to register the server on my laptop.|||Which Server do you mean? SBS or SQL? We have only 1 CD for SQL Server 2005
Standard. Any help is appreciated.
"Steve Z" wrote:
> Well - I found it...
> Just like in the old version, it's installed from the same CD (actually
> DVD!) that the server is installed from.
> The difference, and what stopped me from going forward, was the I had to go
> truly far into the install process - even putting in the product-key - to get
> to a selection list that allowed only the CLIENT TOOLS.
> On a laptop that's already running MS SQL 2000 developers edition - that was
> a big leap to take - possibly installed MS SQL 2005 on the laptop - which I
> did not want to do.
> The readme and help files are pretty vague in this area.
> But at any rate - I've got it installed now on the laptop and it can see the
> MS SQL 2005 server on the network and can even see my laptop instance running
> MS SQL 2000.
> Now I get to play!
> "Matt" wrote:
> > Apparently there are more people having the same problem. Microsoft should
> > address this issue in a KB.
> >
> > Thanks
> >
> > Matt
> >
> > "Steve Z" wrote:
> >
> > > Where do I find the Management Studio to install on my laptop?
> > >
> > > I've just installed MS SQL 2005 on a SBS 2003 machine in the office, and it
> > > says I cannot use regular old EM to register the server on my laptop.|||I mean that the CLIENT TOOLS are installed from the same CD (in our case it's
actually a DVD from MS) that the SQL SERVER is installed from. That is the
same way the old SQL 2000 installed work.
The difference that struck me was that you were told early on in the install
process with SQL 2000 that the CLIENT TOOLS were only available (as the
machine is a workstation!).
With the SQL 2005 install CD you go through many steps, including the
licence-key (not required with SQL 2000 client install).
This appears that you are installing SQL SERVER on the workstation, but you
finally get to a selection screen where you just check off client tools...
"Matt" wrote:
> Which Server do you mean? SBS or SQL? We have only 1 CD for SQL Server 2005
> Standard. Any help is appreciated.
> "Steve Z" wrote:
> > Well - I found it...
> >
> > Just like in the old version, it's installed from the same CD (actually
> > DVD!) that the server is installed from.
> >
> > The difference, and what stopped me from going forward, was the I had to go
> > truly far into the install process - even putting in the product-key - to get
> > to a selection list that allowed only the CLIENT TOOLS.
> >
> > On a laptop that's already running MS SQL 2000 developers edition - that was
> > a big leap to take - possibly installed MS SQL 2005 on the laptop - which I
> > did not want to do.
> >
> > The readme and help files are pretty vague in this area.
> >
> > But at any rate - I've got it installed now on the laptop and it can see the
> > MS SQL 2005 server on the network and can even see my laptop instance running
> > MS SQL 2000.
> >
> > Now I get to play!
> >
> > "Matt" wrote:
> >
> > > Apparently there are more people having the same problem. Microsoft should
> > > address this issue in a KB.
> > >
> > > Thanks
> > >
> > > Matt
> > >
> > > "Steve Z" wrote:
> > >
> > > > Where do I find the Management Studio to install on my laptop?
> > > >
> > > > I've just installed MS SQL 2005 on a SBS 2003 machine in the office, and it
> > > > says I cannot use regular old EM to register the server on my laptop.

MS SQL 2005 Management Studio

Where do I find the Management Studio to install on my laptop?
I've just installed MS SQL 2005 on a SBS 2003 machine in the office, and it
says I cannot use regular old EM to register the server on my laptop.
Apparently there are more people having the same problem. Microsoft should
address this issue in a KB.
Thanks
Matt
"Steve Z" wrote:

> Where do I find the Management Studio to install on my laptop?
> I've just installed MS SQL 2005 on a SBS 2003 machine in the office, and it
> says I cannot use regular old EM to register the server on my laptop.
|||Well - I found it...
Just like in the old version, it's installed from the same CD (actually
DVD!) that the server is installed from.
The difference, and what stopped me from going forward, was the I had to go
truly far into the install process - even putting in the product-key - to get
to a selection list that allowed only the CLIENT TOOLS.
On a laptop that's already running MS SQL 2000 developers edition - that was
a big leap to take - possibly installed MS SQL 2005 on the laptop - which I
did not want to do.
The readme and help files are pretty vague in this area.
But at any rate - I've got it installed now on the laptop and it can see the
MS SQL 2005 server on the network and can even see my laptop instance running
MS SQL 2000.
Now I get to play!
"Matt" wrote:
[vbcol=seagreen]
> Apparently there are more people having the same problem. Microsoft should
> address this issue in a KB.
> Thanks
> Matt
> "Steve Z" wrote:
|||Which Server do you mean? SBS or SQL? We have only 1 CD for SQL Server 2005
Standard. Any help is appreciated.
"Steve Z" wrote:
[vbcol=seagreen]
> Well - I found it...
> Just like in the old version, it's installed from the same CD (actually
> DVD!) that the server is installed from.
> The difference, and what stopped me from going forward, was the I had to go
> truly far into the install process - even putting in the product-key - to get
> to a selection list that allowed only the CLIENT TOOLS.
> On a laptop that's already running MS SQL 2000 developers edition - that was
> a big leap to take - possibly installed MS SQL 2005 on the laptop - which I
> did not want to do.
> The readme and help files are pretty vague in this area.
> But at any rate - I've got it installed now on the laptop and it can see the
> MS SQL 2005 server on the network and can even see my laptop instance running
> MS SQL 2000.
> Now I get to play!
> "Matt" wrote:
|||I mean that the CLIENT TOOLS are installed from the same CD (in our case it's
actually a DVD from MS) that the SQL SERVER is installed from. That is the
same way the old SQL 2000 installed work.
The difference that struck me was that you were told early on in the install
process with SQL 2000 that the CLIENT TOOLS were only available (as the
machine is a workstation!).
With the SQL 2005 install CD you go through many steps, including the
licence-key (not required with SQL 2000 client install).
This appears that you are installing SQL SERVER on the workstation, but you
finally get to a selection screen where you just check off client tools...
"Matt" wrote:
[vbcol=seagreen]
> Which Server do you mean? SBS or SQL? We have only 1 CD for SQL Server 2005
> Standard. Any help is appreciated.
> "Steve Z" wrote:

MS SQL 2000 DTS, how to create connection with Applix TM1 OLE DB MD Provider?

Hi All,

I am trying to connect from MS Analysis Services 2000 to Applix TM1.
Applix has got Applix OLE DB MD Prodiver.It is installed on my machine.
I create a datasource in MSAS.
In Data Link I can see the this Applix OLE DD driver and I choose it. Then I can see Applix login and password screen. Then I logged in. When I test my connection, the connection is succeed.
But when I create a cube from data source,it gets an error message as below;

Connection teamnb-cem data source failed.
Object or provider is not capable of performing requested operation
Do you want to retry_?

How can I fix it?

BEst Regards

Cem DAGLI

AS2000 has list of supported providers, and TM1 is not one of them. There are many requirements for OLEDB provider to work properly with AS2000, so I am not optimistic you will succeed with this kind of direct connection. I suggest exporting data from TM1 cube into SQL Server first, and then processing AS2000 cube off SQL Server.|||

Dear Mosha,

I am using Applix OLE DB MD Provider. Not Microsoft providers.
When you install Applix , you have Applix OLE DB MD provider. I connected from Excel to Applix TM1.
But for AS2000 not.

Does AS2005 support Applix OLE DB MD Provider? If I try it from MSAS 2005 ,can I connect it?

Best Regards
Cem dAGLI

|||So, what exactly do you mean when you say "Connect AS2000 to Applix". The only way AS2000 "connects" to external databases is for processing or ROLAP, and there is a list of supported providers (SQL Server, Oracle etc) - Applix is not on that list.|||

Dear Mosha,

I mean connect from MSAS 2000 to Applix TM1 OLAP Server.

There is a Applix OLE DB MD Provider in Data Link screen in MSAS 2000. The Driver is provided by Applix.
I also connected from MS Excel to Applix OLAP server with this driver.
If you send me your e-mail , I will send all printed screen in MSAS 2000.

Best Regards

Cem DAGLI

|||

Cem

Unfortunately, you don't make yourself clear - you just repeated the information that you already provided earlier. The only way the statement "connect MSAS 2000 to Applix TM1 OLAP Server" can be interpreted is that you try to process MSAS cube out of the TM1 cube, and use Applix OLEDB provider for that. As I explained above - this is not supported scenario. If you have some clarifying screenshots - please attach them to this post.

|||

Hi Mosha,

I need to extract some data from Applix TM1 cubes into MS SQL Server. Here are the steps i tried to create a connection in MS SQL 2000 DTS package using Applix TM1 OLE DB MD Provider (v8.4.2).

1) Create a new DTS package
2) Add Connection Properties. Applix TM1 OLE DB MD Provider is not listed in the 'Data Source' list. So i choose Microsoft OLE DB Provider for OLAP Services 8.0

3) Click Properties...

4) On Provider tab, choose Applix TM1 OLE DB MD Provider.

5) On Connection tab, specify the TM1 server location & instance. Test Connection is successful.

6) Click OK to complete the configuration.

When i edit the connection properties again, the provider reverts to Micosoft OLMicrosoft OLE DB Provider for OLAP Services 8.0. It doesn't seem to save the configuration done above.

Could you please shed some lights on how to get this to work? Thanks a lot.

MS SQL 2000 Backup. where r my Indexes?

I used Enterpise manager to make a backup of a SQL Database. When I
restored it on another machine, I did not have any of my indexes. I
checked the backup wizard and I could not find any reference to
including or not indexes.
Are my indexes there, but not built? Maybe a stored procedure I need
to run to rebuild them?
TIA
Rob"R Camarda" <rcamarda@.cablespeed.com> wrote in message
news:d7938492.0407150406.3b114fb0@.posting.google.c om...
> I used Enterpise manager to make a backup of a SQL Database. When I
> restored it on another machine, I did not have any of my indexes. I
> checked the backup wizard and I could not find any reference to
> including or not indexes.
> Are my indexes there, but not built? Maybe a stored procedure I need
> to run to rebuild them?

This is very weird.

I'd try to do a backup and restore using query analyzer just to confirm
everything.

A restore should be an intact copy of the database.

> TIA
> Rob|||A restored database is exactly like the original, although file locations
may be changed during the restore. You might check your backup file to see
if it contains multiple backup sets. By default, the first (oldest) backup
is restored and perhaps that version didn't have your indexes.

You can list the contents of your backup with RESTORE HEADERONLY. For
example:

RESTORE HEADERONLY FROM
DISK='C:\Backups\MyDatabase.bak'

--
Hope this helps.

Dan Guzman
SQL Server MVP

"R Camarda" <rcamarda@.cablespeed.com> wrote in message
news:d7938492.0407150406.3b114fb0@.posting.google.c om...
> I used Enterpise manager to make a backup of a SQL Database. When I
> restored it on another machine, I did not have any of my indexes. I
> checked the backup wizard and I could not find any reference to
> including or not indexes.
> Are my indexes there, but not built? Maybe a stored procedure I need
> to run to rebuild them?
> TIA
> Rob

MS SQL & Visual Studio 2005

I want to install SQL on the same machine as VS 2005 Pro for development.
While trying to install the version of SQL that comes with the VS 2005 Pro
I'm getting error messages and the SQL engine will not start. Is it
possible to have the SQL install on the same machine as the VS 2005 or do I
need to install the personnel edition instead? What should I do?

Charles MacLean
MTS, Inc.Charles MacLean (charlesmaclean@.sbcglobal.net) writes:

Quote:

Originally Posted by

I want to install SQL on the same machine as VS 2005 Pro for
development. While trying to install the version of SQL that comes with
the VS 2005 Pro I'm getting error messages and the SQL engine will not
start. Is it possible to have the SQL install on the same machine as
the VS 2005 or do I need to install the personnel edition instead?

That should be possible.

Quote:

Originally Posted by

What should I do?

You could always post the error messages you get...

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx