Tracking Forums, Newsgroups, Maling Lists
Home Scripts Tutorials Tracker Forums
  Advanced Search
  HOME    TRACKER    MS SQL Server


SuperbHosting.net have generously sponsored dedicated servers to ensure a reliable and scalable dedicated hosting solution for BigResource.com.





Microsoft Management Console Snap-in For Windows 2000


Hi,

Anybody know where I can download the Microsoft Management Console Snap-in for Windows 2000 operating systems?


Thanks in advance,
Faustina




View Complete Forum Thread with Replies

Related Forum Messages:
Microsoft Management Console Snap-In Failed To Initialize
 
Uninstalled an older version of SQL and installed SQL Express 2005
In Computer Management Dialog box, when you click on Services and Applications, you the following error dialog box:
Microsoft Management Console
   Snap-In Failed to initialize
      Name: Microsoft SQL Enterprise Manager
      CLSID{xxxx€¦xxx} (where x is the actual CLSID)
Microsoft SQL Enterprise Manager was uninstalled.  How do I get rid of this dialog box?  Everything is working fine.
Thanks
Bob

View Replies !
Microsoft Management Console Nice Update!
Hi,
There is a tool you can install it to change the behavior of the Management Console, when you double-click on a table it will fire the Return All Rows command instead of the Properties command.
I already saw this change but could not know where to get it from, any one of you know it?

Thanks,

View Replies !
The Selected File Is Not A Microsoft Management Console Document
Any idea on what this error is?I am not able to open Enterprise Manager in SQL server 7.0.Thanks.

View Replies !
64 Bit - Windows Liberty 64bit, Windows Limited Edition 64 Bit,Microsoft SQL Server 2000 Developer Edition 64 Bit, IBM DB2 64 Bit - New!
64 bit - Windows Liberty 64bit, Windows Limited Edition 64 Bit,Microsoft SQL Server 2000 Developer Edition 64 Bit, IBM DB2 64 bit - new!Windows Liberty 64bit 8403Windows Limited Edition 64 Bit Edition 8764Microsoft SQL Server 2000 Developer Edition 64 Bit 12 000IBM DB2 UNIVERSAL CONNECT ENTERPRISE EDITION V8.1.2 64BIT 12 211IBM DB2 Administration Client V8.1.2 64bit W3KSERVER 12 266IBM DB2 UDB Enterprise Server Edition V8.1.2 64Bit W3KSERVER 12 284IBM DB2 Connect Applic Server Edition V8.1.2 64bit W3KSERVER 12 392IBM DB2 Spatial Extender v8.1 64Bit Multilanguage 12 610If you have Googled your butt off, and haven't come up with anything...., and for 14,000 more reasons, please send e-mail,Join Bytes!, Join Bytes!, Join Bytes!,

View Replies !
New SSB-Management Console
Hi,

we are currently planning the development of a new SSB-Admin-Tool for SOA environments, which will allow dynamic configuration during MSBuild, register and monitor all services, dynamically configure routes (supporting gateway-servers and services registered on multiple servers for fail-safe).

I would like to know if MS is currently working on something similar (the Service-Listing-Manager is buggy, old and seems to be dead on GDN) and what the community thinks.

View Replies !
Server Management Console Only??
Can the Server Management Studio Express be installed on a machine without SQL Server Express?

I have a machine that I use daily that I need to access a remote instance but there is not a need (or space) to fully install SQL Server onto the local machine - all I need is the management tool.

I tried installing it but the process errors out, saying a pre-requisite (MSXML6) isn't found. It refers me to a site with all the different SQL Server downloads.

All I need is the management tool on this machine. Is there a way to do it?

Tried loading "MOM" but it doesn't show up either

Thanks

Paul P

View Replies !
SQL Express And Management Console Ctp Issue
So i installed sql express and the management console and have the sql service and browser running.  I try to connect to my instance of sql express with the management console and it says it doenst allow remote connections.
error:  http://img95.imageshack.us/my.php?image=error28to.jpg
What do i need to do to be able to use the management console?
I was able to connect before but due to some bad advice think i stuffed up the whole thing and had to uninstall sql express and the management console.   I re-installed them both but am now getting this error.  what the heck is the deal with this?  It shouldnt be this hard!
This is in relation to an earlier issue i had trying to get to connect to a database from within visual web developer express and now i can connect to my sql express instance but cant get into the managment studio.  :(

View Replies !
Connection Issue With Management Console
When i try to connect to Integration Services on a SQL 2005 Machine, it Gives me a Class not registeed.
But i can connect to  SQL 2008 Integration Services without a issue.
I tried Restarting the 2008 machine and Also Reinstalling the SSIS Piece and also Reinstalled SQL 2008, but nothing seems to Help.

View Replies !
SQL Server 2005 Management Console
We installed SQL Server 2005 x64 on a server for our client here at our office.  We can't connect to it using Enterprise Manager.  I'm assuming we need to install the management console because of the differences in 2000 and 2005.  The install is for a x64 and our workstations are x32.  Do I need to get a media kit for a x32 because the x64 install won't work.  Where can I get the install for the x32 Management console and will this work?

View Replies !
Management Console In Enterprise Manager Error
hi, I always get DR Watson fir Window NT when I test Operators under the Management console. I have created a new operators and when I go to the property to test the email and the pager notification, I get Dr Watson and Sql Server Enterprise disappear.

I am not sure what is going on and if there is someone knows what is going on,please let me know
thanks for your help

Ahmed

View Replies !
Database Engine Not Displayed By Management Console
I have sql server 2005 express installed on an XP machine. When I browse for a database engine, SQL server 2005 management console displays machinenamesqlexpress in the local tab, BUT in the network tab only the machinename is displayed. Thus, I cannot connect to express from a networked machine.

 

Any help would be appreciated.

 

TIA,

Joe

View Replies !
SQL Server Management Console Express And Linked S
Ok so I managed finally to get an Excel Spreadsheet to connect as a linked server.

When I right click it , go to run scripts and click on create to i can see the tab of script below:

/****** Object: LinkedServer [EXCELLINK] Script Date: 05/17/2008 08:37:04 ******/
EXEC master.dbo.sp_addlinkedserver @server = N'EXCELLINK', @srvproduct=N'Excel', @provider=N'Microsoft.Jet.OLEDB.4.0', @datasrc=N'c:PRICINGFINAL2.xls', @provstr=N'Excel 8.0'
/* For security reasons the linked server remote logins password is changed with ######## */
EXEC master.dbo.sp_addlinkedsrvlogin @rmtsrvname=N'EXCELLINK',@useself=N'False',@locallogin=NULL,@rmtuser=NULL,@rmtpassword=NULL

GO
EXEC master.dbo.sp_serveroption @server=N'EXCELLINK', @optname=N'collation compatible', @optvalue=N'false'
GO
EXEC master.dbo.sp_serveroption @server=N'EXCELLINK', @optname=N'data access', @optvalue=N'true'
GO
EXEC master.dbo.sp_serveroption @server=N'EXCELLINK', @optname=N'dist', @optvalue=N'false'
GO
EXEC master.dbo.sp_serveroption @server=N'EXCELLINK', @optname=N'pub', @optvalue=N'false'
GO
EXEC master.dbo.sp_serveroption @server=N'EXCELLINK', @optname=N'rpc', @optvalue=N'false'
GO
EXEC master.dbo.sp_serveroption @server=N'EXCELLINK', @optname=N'rpc out', @optvalue=N'false'
GO
EXEC master.dbo.sp_serveroption @server=N'EXCELLINK', @optname=N'sub', @optvalue=N'false'
GO
EXEC master.dbo.sp_serveroption @server=N'EXCELLINK', @optname=N'connect timeout', @optvalue=N'0'
GO
EXEC master.dbo.sp_serveroption @server=N'EXCELLINK', @optname=N'collation name', @optvalue=null
GO
EXEC master.dbo.sp_serveroption @server=N'EXCELLINK', @optname=N'lazy schema validation', @optvalue=N'false'
GO
EXEC master.dbo.sp_serveroption @server=N'EXCELLINK', @optname=N'query timeout', @optvalue=N'0'
GO
EXEC master.dbo.sp_serveroption @server=N'EXCELLINK', @optname=N'use remote collation', @optvalue=N'true'

Now I am not sure exactly how to go about querying to pull the data into a table.

The table I want to set will have three columns:

CREATE TABLE new_price (
item_id CHAR(12),
item_lst_lnd_cost DECIMAL(9,2),
item_prc_2 DECIMAL(9,2))

the columns in the EXCELLINK linked server spreasdsheet are named the same as the columns above. Once the table is created how do I use the linked server to import the data?

Brooks C. Davis
IT AdministratorLogistics Manager SFTF LLC dba Ashley Furniture Homestores
DELL POWEREDGE 2850 Dual Core Xeon x3 = 1xDB 1xSQL 1xTS | DELL POWEREDGE 2950 Quad Core Xeon = 1xTS | SERVER 2003 | MS SQL 2005 | PERVASIVE EMBEDDED V.9

View Replies !
Accessing Remote SQL Server Management Console From The Web Browser?
How does one access a remote SQL Server from the web browser?

Thanks,

-Conrad

 

 

View Replies !
Microsoft##EESS And MSDE SQL 2000 On Windows 2003 Small Business Server
Currently a server running 2003 small business operating system has MSDE 2000 and Microsoft##SSEE.

A memory problem exists with SQL consuming over 50% of RAM. Total RAM is 4GB.

There is a SQL 2000 patch for this type of problem. However, it calls for SQL to be upgraded to SP4.

Problem:
Can this MSDE 2000 be upgraded with SP4 and have memory patch applied with Microsoft##SSEE also on this box?

 

Please let me know. Thank you.

View Replies !
Does Anyone Know How To Modify Table Structure In Sql Server Management Console(2005)? Thanks
does anyone know how to modify table structure in sql server management console(2005)? thanks

View Replies !
SQL Server 2000 Enterprise Manager Snap-in Missing
After running virus cleaning software on my HD, I suddenly find my Enterprise Manager snap-in missing and fail to initialize. Is the MMC erased or damaged? What should I do? Reinstall SQL Server 2000 or repair it? Please advise. Thanks.

View Replies !
Is SQL Server 2005 Management Studio (client Components Only) Is Compatible With Windows Server 2000?
Hi,
 
Pls let me know if SQL Server 2005 Management Studio (client tools only) is compatible with Windows Server 2000 or not?
 
Thanks in advance.
 
Regards,
Bhuvana

View Replies !
Microsoft.SqlServer.Management
I am looking for a way to script out all tables within a SQL Server 2005 database using VB.NET. I am writing a backup utility and have been able to do stored procedures, the data within the tables, but am now stuck on scripting out the tables with their primary keys, indexes, etc. Sure, I could hard-code some stuff like "CREATE TABLE dbo" & strTable, but I am pretty sure there is a way to do it within VB.NET using SMO. So, any help that someone could offer is greatly appreciated.
Thanks

View Replies !
Microsoft SQL Server Management Studio
I was looking for Microsoft SQL Server Management Studio but downladed Microsoft SQL Server Management Studio EXPRESS.
the express version doesn't have the SQL server agent. I read that the express doesnt support SQL server agent. Is there any add-on or service pack available for this.
I am trying to find "SQL server Management studio". Any idea where I can download it?

View Replies !
Microsoft SQL Server Management Studio
i try to open database table using Microsoft SQL Server Management Studio i got the follwing error msg i don't know what the problem
 
===================================
Object reference not set to an instance of an object. (SQLEditors)
------------------------------Program Location:
   at Microsoft.SqlServer.Management.UI.VSIntegration.Editors.OpenTableNode.CreateDesigner(IDTDocToolFactoryProvider factoryProvider, IVsDataConnection dataConnection)   at Microsoft.SqlServer.Management.UI.VSIntegration.Editors.VsDataDesignerNode.CreateDesigner()   at Microsoft.SqlServer.Management.UI.VSIntegration.Editors.VsDataDesignerNode.Open()   at Microsoft.SqlServer.Management.UI.VSIntegration.Editors.VirtualProject.Microsoft.SqlServer.Management.UI.VSIntegration.Editors.ISqlVirtualProject.CreateDesigner(Urn origUrn, DocumentType editorType, DocumentOptions aeOptions, IManagedConnection con)   at Microsoft.SqlServer.Management.UI.VSIntegration.Editors.ISqlVirtualProject.CreateDesigner(Urn origUrn, DocumentType editorType, DocumentOptions aeOptions, IManagedConnection con)   at Microsoft.SqlServer.Management.UI.VSIntegration.Editors.VsDocumentMenuItem.CreateDesignerWindow(IManagedConnection mc, DocumentOptions options)
 

View Replies !
Microsoft SQL Server Management Express...help
Hi,im trying to learn SQL Server Management Expressknow a good place to start?Im trying to upload an sql database from Visual Web DeveloperIve been told that this can be done using SQL Server manegement express...cant see how to import into it yet....   any ideas?

View Replies !
This Is Related To Microsoft Operations Management
We would like to use MOM to monitor every problem in SQL Server. I was trying to find all the MOM rules corresponding to severity 17 to severity 25 errors. But there are a lot of the errors don't have the matching MOM rules, I wonder if someone can help me or direct me to the proper place.

 

For example,

 

error 8653, severity 17. Warning: The query processor is unable to produce a plan because the table '%.*ls' is marked OFFLINE

 

I can't find corresponding MOM rule for it.

 

 

Thanks in advance,

Rose 

View Replies !
Trigger - Microsoft SQL Server Management Studio
Hi,
How to create Trigger in "SQL SERVER 2005 - Microsoft SQL Server Management Studio"? This is my 1st interaction with SQL SERVER 2005.



Thanks,
Rahul Jha

View Replies !
Where Can I Find Microsoft.SqlServer.Management.Smo Namespace?
Hello,
 
Where can I find the reference to Microsoft.SqlServer.Management.Smo in SQL Server 2005?
 
I currently have Microsoft SQL Server 2005, Microsoft SQL Native Client and Server VSS writer installed. (and ran the Service Pack 2 installer, but it doesn't want to update 'Database Services')
 
 
Thanks in advance,
 
Ruben Pieters

View Replies !
Query Abt Microsoft SQL Server Management Studio
 

Hi all,
I am Vaibhav.I am using Microsoft SQL Server Management Studio 9.00.1399.00 on my machine , which have Windows 2000 Professional OS installed. Now I am upgrading My ystem to Windows Vista OS.
And I am not getting whether Microsoft SQL Server Management Studio 9.00.1399.00 will support Windows Vista?  or    I have to go for Higher version available for Microsoft SQL Server Management studio ?                                
Please asist me on same.
 
Thanks,
 
Vaibhav Tare
 

View Replies !
Microsoft SQL Server Management Studio Express
 

Is Microsoft SQL Server Management Studio Express (sql 2005) compatible with Sql Server 2000 databases?
I'm using Windows Vista and the sql 2000 Enterprise Manager is not fully compatible with Vista...long not responding messages.
Can i use the client version of Slq 2005?
 
Regards

View Replies !
ODBC Driver For DBase Can't Use NDX File With Substr(col,x,y) On Windows 2000. OK On Windows XP
Summary of problem:

 

Trying to read a dBase (*.dbf) that has an index (*.NDX) file via the Microsoft dbase (*.DBF) ODBC driver .  On WindowsXP it works fine in all test cases but on Windows 2000, if the index was created with a substr(column,start,end) command, then it fails with "DIAG [HY010] [Microsoft][ODBC Driver Manager] Function sequence error (0)"


Details:


Trying to integrate with a 3rd party application to build a data adapter that simply reads data from their *.DBF files.  The app uses a dBase III compatible file with *.NDX files for indexing of various tables.
Integration should be straight-forward use of an ODBC definition pointing to the directory containing the files which works fine for most cases except one table that has an index file created with a substr(column,start,end) type command when the application is running on Windows 2000.

 


SAMPLE.DBF file
Fields
field1(char12),field2(char1),field3(char1),policynum(char25),field4(char8),field5(char8)
aaaa1,0,0,AB1234567,x,y
bbbb2,1,1,AB1237890,x,y
cccc3,0,0,AB1245213,y,y

 

SAMPLE.NDX:  index on field1
  SAMPLENUM.NDX:  index on substr(policynum,1,22)

 

Created SAMPLE.INF via ODBC manager as follows:
[dBase III]
NDX1=sample.ndx
NDX2=samplenum.ndx

 

Sample Query: 
select * from C:SAMPLE.DBF where policynum='AB1237890'

 

Test Results:


 

Test 1a.  On WindowsXP:  success - single row is returned.  Trace of file access details (FILEMON.EXE) shows ODBC driver opens the SAMPLE.INF to read it, then the SAMPLENUM.NDX, and then the SAMPLE.DBF


Test 1b.  On Windows2000:  Fails.  Output of SQL.LOG from ODBC Manager trace has the following error:
PolicyExtractor 39c-2b4 ENTER SQLExecDirectW
  HSTMT               07B818C8
  WCHAR *             0x04A0987C [      -3] "select * from C:SAMPLE.DBF where policynum='AB1237890' d a 0"
  SDWORD                    -3

PolicyExtractor 39c-2b4 ENTER SQLRowCount
  HSTMT               07B818C8
  SQLLEN *            0x0012BC18

PolicyExtractor 39c-2b4 EXIT  SQLRowCount  with return code -1 (SQL_ERROR)
  HSTMT               07B818C8
  SQLLEN *            0x0012BC18

  DIAG [HY010] [Microsoft][ODBC Driver Manager] Function sequence error (0)

PolicyExtractor 39c-2b4 ENTER SQLMoreResults
  HSTMT               07B818C8

PolicyExtractor 39c-2b4 EXIT  SQLMoreResults  with return code 100 (SQL_NO_DATA_FOUND)
  HSTMT               07B818C8

 

Test 2: attempt to use the other index file
select * from C:SAMPLE.DBF where field1='bbbb2'
On Windows XP:  success - single row is returned
On Windows 2000:  fails - same error as above

 

Test 3:  Remove the SAMPLE.INF

select * from C:SAMPLE.DBF where field1='bbbb2' 

or

select * from C:SAMPLE.DBF where policynum='AB1237890'
On Windows XP:  success - single row is returned
On Windows 2000:  success - single row is returned
In both cases, FILEMON shows the SAMPLE.DBF being opened and read many times (full table scan). 
Note: This is an unacceptable permanent configuration for performance reasons.

 

Test 4:  SAMPLE.INF with only entry for field1 index:
[dBase III]
NDX1=sample.ndx

 

select * from C:SAMPLE.DBF where field1='bbbb2'


On Windows XP:  success - single row is returned
On Windows 2000:  success - single row is returned
In both cases, FILEMON shows that SAMPLE.INF is opened, then the SAMPLE.NDX, and then the SAMPLE.DBF for single record access.


 

Test 5:  SAMPLE.INF with only entry for policynum index:
[dBase III]
NDX1=samplenum.ndx

 
select * from C:SAMPLE.DBF where policynum='AB1237890'


On Windows XP:  success - single row is returned
On Windows 2000:  Fails with same output as in test 1b above.
In both cases, FILEMON shows that SAMPLE.INF is opened, then the SAMPLENUM.NDX, and then the SAMPLE.DBF

 


File & OS info:

MDAC 2.8 SP2 installed
Microsoft dBase Driver (*.dbf)
On WindowsXP   version 4.00.6304.00    ODBCJT32.DLL   8/4/2004
On Windows2000 Pro   version 4.00.6200.0    ODBCJT32.DLL  6/18/2003

 

The following links have been generally helpful but haven't resolved the issue:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/odbc/htm/odbcsqlallochandle.asp - but we added the prepare() function call and there was no difference. Confirmed same result using a third party app
http://www.edu.yar.ru/docs/odbc/odbc4/chap08.htm  (interesting ... but...)


 

Many thanks if anybody can help resolve this problem!

Jeff

View Replies !
Microsoft SQL Server Management Studio Express Problem
Microsoft SQL Server Management Studio ExpressI have restored the database into it with 100tables and stored procedures.I have also created the new database in it.But,i don't know how to add the existing database in to Visual Studio.Net 2005 .I m using ASP.Net.Where are the database stored ?? I don't want to create the new database,.Can anyone pls tell me ....

View Replies !
Microsoft.SqlServer.Management.Smo Backup And Restore Classes
Hi,

Hopefully someone out there will be able to help me with this question. I'm trying to setup my C# program to use the Backup and Restore classes to perform backups and restores on an SQL Express 2005 database.

From the documentation I've read... it seems that when you go to restore the database, it's a good idea to backup the current transaction log. But when I do this using the Backup.SqlBackup method I get an error saying that no database backup is detected so a log backup can't occur. I'm not sure if this has something to do with the fact that I moved my backup files from the default SQL Express/Server Backup folder to a different location. Shouldn't it know I've already performed a backup though?

And does anyone know how to set a parameter to backup to a different file location than the default? I've been doing a backup then a file move. Works the same, but it would be nice to have everything together in the Backup object.

Thanks!

View Replies !
The Machine Could Not Be Found (Microsoft.SqlServer.Management.UI.RSClient)
We are getting this error when we try and log on to a Reporting Services connection  Via SQL Server Management Studio on a client Machine. It works fine if we are on the Server.   

We can logon to the Database Engine just fine (from the Client) and the Web version of the Report manager Works fine too.

Any help would be appreciated!!!1

 






 

Code Snippet

The machine could not be found (Microsoft.SqlServer.Management.UI.RSClient)

 

Edit:

W've gotten a little farther.  We have determined that The users who are in the "BuiltinAdministrators" Group can Connect to the Report Server from a client machine but the users that we are  trying to fix are not in that Group, But they are in a Group that we added to the SQL Security. We have that group setup like the Admin group, but we still can't get them to Connect

 

 

View Replies !
Is It Possible To Create A DTS Package Using Microsoft Sql Server Management Studio
Is it possible to create a DTS package using microsoft sql server management studio. if yes? How can i do it.

 

Any help is appreciated.

 

Regards,

Karen

View Replies !
HTTP 400: Bad Request (Microsoft.SqlServer.Management.UI.RSClient)
Hi all,

 

I need your help on the following:

 

I can't connect to Reporting Services from SQL Server Management Studio. I get the following error message:
"No connection can be made with SERVER. Additional information: Error at request with HTTP-Status 400: Bad Request (Microsoft.SqlServer.Management.UI.RSClient)"

 

What is wrong?? I'm running SQL Server 2005 SP2 on Windows Server 2003 hosting on an internet server.

 

Thanks in advanced!!

 

CarRoussel

View Replies !
Status 401: Unauthorized. (Microsoft.SqlServer.Management.UI.RSClient)
We are in the process of setting up a test server for reporting services in which the reporting server is on a seperate IIS server as the SQL Database.  I was able to resolve a previous error I was receiving when connecting to reporting services using SQL server management studio and within SQL Surface Area Configuration (HTTP Status 404: Not Found. ((Microsoft.SqlServer.Management.UI.RSClient)) by editing the URLRoot in the rsreportserver.config file.  But now whenever we try to connect using SQL Management Tool from other than on the server we receive this new error:
 
TITLE: Connect to Server
------------------------------
 
------------------------------
ADDITIONAL INFORMATION:
The request failed with HTTP status 401: Unauthorized. (Microsoft.SqlServer.Management.UI.RSClient)
------------------------------
BUTTONS:
OK
------------------------------

 
Any Thoughts?

View Replies !
Reinstalling Microsoft Server Management Studio Express
 

I was having some trouble with the DTS Wizard and so I thought I'd just reinstall the whole MSSM. I used remove programs, rebooted my Vista computer and am trying to reinstall the Server Express Toolkit. It tells me that MSSM already exists on my computer (which it doesn't).
 
The actual screen reads:
 
Existing components
The following components that you chose to install are already installed on the machine.
Grayed out -- Workstation components and development tools 9.2.3042.00
 
How do I reinstall MSSM now? It's gone from my computer.
 
Thanks!

View Replies !
Problem In Attaching Database (Microsoft Management Studio)
I want to change a database to different physical file. So i try the following step:

Detach the database
Attach the new different file

But i get an error "....... SQL server, error:5133".

It still needs the original file.

How to solve this problem?

many-many thanks,

JRLiem

 

View Replies !
How To Get Started On Microsoft SQL Server Management Studio Express
Hi,

Was trying to open AdventureWorks when i got this error: "There is no editor available "C: Program Flies.....AdventureWorksDW_Log.LDF'
Make sure the application for the file type(.LDF) is installed.
How can this error be corrected? I also have some error on mdf not installed.May i know how should be the initally steps to be done inorder for me to view this database.
And if i do have a database from microsoft access, what are the steps that i need to do inorder to get it export to Microsoft SQL Server Management Studio Express. Please advise as i really new to it. Thanks!

View Replies !
Microsoft SQL 2005 Express Management Tool-errors
Hi guys, I've tried to back a database from a server on the net ie: discountasp.net by using Microsoft SQL 2005 Express management tool.
After all the set up:
(1) the part "Destination", in the "Disk" radio button was cheked, the path for the backup file shows like: D:MSSQL.1MSSQLBackupmyDatabase.back; As I understand D: is the CD drive(?), so I put a CDisc in the drive, and kept going with the process. The Process went very well and inform that the Database has been fully backed up. But I never have found the "saved" or "backed up" that I backed up. Can anyone show me where this backup Database in that D: drive, and where is that D: drive anyway?

(2) In that "destination" part, if I clicked "add", and then typed in the path address part like: C:....mybackupDatabase.bak for example, the the tool gave me the error: ... not set to an instance ...; I counldn't even select the Browse to browse to the directory that I wanted to back up the Database.

Please help me for this.
Regards.
Joey

View Replies !
Connection Problem To Sql 2000 On Windows 2003 From Windows 95
Hi all,I have a Windows 2003 server, which is also a terminal server forapplication, with sql 2000 installed. My company has developed anapplication that uses SQL 2000 as its database. The application is aclient/server one. In each client computer there's a link to theapplication on the server. There is no problem with Windows 98,Windows 2000 pro, Windows xp pro clients, but the windows 95 onescannot log in to the database. The log of the application shows thefollowing error:connection error -2147467259. Cannot open database requested in login'database name'. Login fails.Till a week ago the application was running on a Windows 2000 serverwith SQL 2000 install and the W95 clients had no problem connecting tothe database, so my guess is the error has something to do withWindows 2003 server, but what'causing the error?I tried to install a newer version of MDAC (MDAC 2.5, the last versionof MDAC you can install on W95)but with no success. By the way W95clients have no problem accessing shared folder on the Windows 2003server.Any idea?ThanksMarino

View Replies !
Moving SQL Servr 2000 From Windows 2K Server To Windows 2K3
 

Does any one come across any difficulty in the following migration?
OS: Wondows Server 2K
DB: SQL Server 2K Standard Edition

 
Migrating to
OS: Wondows Server 2K3
DB: SQL Server 2K Standard Edition

 
Thank you,
Gish

View Replies !
Microsoft Sql Server Management Object--Getting Problem In Defining DataType
Hiii
     I am working on a application where I will upload my excel sheet.Then the application will read the header and will create a table to store the excel sheet.
When the excel sheet will be uploaded first it will read the header of the excel and will display it inside a gridview to choose which columns are to be created along  with datatype.I am giving u a snapshot



Column Name
Select
Datatype

Group Code



Emp No



Mem code



Amount


So Here the user is selecting tha data type.So I am passing the data type to my functions.But while assigning the datatype I am getting error that can no convert from sting to Microsoft.SqlServer.Management.Smo.DataType.I am giving u the demo codeprivate void button1_Click(object sender, EventArgs e)
{ServerConnection objsvrconn = new ServerConnection();
objsvrconn.LoginSecure = false;objsvrconn.ServerInstance = "DEMO";
objsvrconn.Login = "sa";objsvrconn.Password = "sa";
Server objsvr;objsvr = new Server(objsvrconn);
//objsvr.ConnectionContext.Connect();Table tb = objsvr.Databases["Demo"].Tables["Temp"]; Column c = new Column(tb, "GrpCode");
DataType dt = new DataType();dt.SqlDataType =(DataType)"Varchar" ---I am getting the error here.It only accecept from a enum i.e Datatype.Typename but doesnot accept like this
dt.MaximumLength = 10;
c.DataType = dt;
tb.Columns.Add(c);
tb.Alter();
}
 
Please help me.

View Replies !
Can't View .mdf Files In Microsoft SQL Server Management Studio Express
I am unable to view any .mdf files in Microsoft SQL Server Management Studio Express, even though it is looking for an .mdf extension.  Why is this?  Is this a limitation of the Express version?More specifically i want to view the aspnetdb.mdf file that is created with each web application.Any thoughts?  Thanks.Jason

View Replies !
Database Sizing For Microsoft Content Management Server 2002?
Hi,I am involved in planning the roll-out of Microsoft Content ManagementServer 2002, and am looking for database server sizing (data, logs,tempdb, etc) for a set of "typical" sizings, but cannot find anything.Does anyone out there have anything like this?TIA,Andy

View Replies !
Can't Connect To Reporting Services Using Microsoft SQL Server Management Studio
When I try to connect to the Reporting Services using Microsoft SQL Server Management Studio, the following error message propmpts up:

_____________________________________________________________
ADDITIONAL INFORMATION:
The request failed with HTTP status 401: Unauthorized. (Microsoft.SqlServer.Management.UI.RSClient)
_____________________________________________________________

Is there any settings that I need to do in the "Reporting Services Configuration Manager" ?

Thanks.

Best regards,

Michael Wu

View Replies !

Copyright © 2005-08 www.BigResource.com, All rights reserved