Enterprise Manager And SQL Server Express 2005

Sql Server 2005 Express/management && Enterprise Manager
I have presently installed on my local computer Enterprise Manager for access to our remote sql server. May I install sql server 2005 express and sql server  management studio express on my local computer without causing conflicts with Enterprise Manager?

 

thanks,

damiata

View Replies !

---

Remotely Register SQL Server 2005 Express In Enterprise Manager
 
I have SQL Server 2005 Express installed on a windows server 2003 standard edition. I have configured the windows firewall to allow exceptions for sqlservr.exe and sqlbrowser.exe. I have enabled remote and local connections using tcp/ip & Named Pipes through the Sql Server Surface Area Connection utility. I am able to telnet into the server with: telnet <server ip> <1433>.
 
Here is the strange part: I am able to connect to the Sql Server remotely from a development machine via Sql Server Management Studio Express, but I am unable to connect to the Sql Server from the same development machine by registering it in Sql Server Enterprise Manager...Is it possible to register SQL Express through Enterprise Manager?
 
When registering the SQL Express DB in Enterprise Manager I tried both just the (IP Address) of the server and the (IP AddressSQLExpress) as the server/host but I am getting the following errors from enterprise manager:
 
Just the (IP Address) as the server/host:
Invalid Connection.
ConnectionOpen( Invalid Instance())
 
(IP AddressSQLEXPRESS) as the server/host:
Sql Server does not exist or access denied. ConnectOpen(Connect()).
 
Any idea why I can€™t register/mount the instance remotely in Enterprise Manager
but I can in Sql Server Management Studio Express?
 
Thanks,
 
Greg

View Replies !

---

Enterprise Manager For SQL 2005 Express
Hi,

Ive received a .bak file of our company db from our hosting company and would like to import it into the SQL 2005 Express machine however, Ive never done this before using 2005. Previously with SQL 2000, I used the enterprise manager to view/import data into the database but Im unable to find this feature with 2005.

Can anyone help me?

Thanks

DW

View Replies !

---

Will Installing Sql Server Management Studio Express Upgrade Enterprise Manager?
I was wondering if i install sql server management studio express (05) on a pc with enterprise manager(00) on it, if that will upgrade the enterprise manager?  I was hoping to have them installed side by side so that i can manage my sql server 2000 dbs on a server with enterprise manager and manage a sql express 05 db i have on another pc with the managment studio.Thanks!

View Replies !

---

Enterprise Manager For SQL Server 2005?
 Hi, I am new to Sql Server 2005. I have worked previously in Sql Server 2000. I want to know if Enterprise Manager exists in Sql Server 2005. If yes, then where?  Regards,ap.  

View Replies !

---

View SQL Sever 2005 Express Database On SQL Sever Enterprise Manager
Is it possible to connect SQL Sever 2005 Express from SQL Sever 2000 Enterprise Manager? Tried to connect but got the error message "must use SQL Server management tools to connect this sever" 

Thanks

 

View Replies !

---

Not Seeing Enterprise Manager After Installed Sql Server 2005
I am installing Sql Server 2005 on top of WindowsSBS 2003 and VS 2005. After I finish installing it I cannot see where the enterprise manager is. Basically I only get Microsoft Sql Server COnfiguration tools. Am I doing something wrong or this is the way it is suppose to be? I had installed all the features from SQL Server 2005.
I appreciate any help!

View Replies !

---

I Just Installed Sql Server 2005. Where Is Enterprise Manager? And About Reporting..
1. So do I use that free tool SQL tool SQL Server Management Studio Express  with the real version of SQL 2005? I do not see any program like enterprise manager that sql 2000 came with
 
2. We use Crystal reports 8.0 now. I noticed a new verison of crystal reports and also SQL reporting tools. But I am confused how the pricing works..  and which would cost more to use on production.. anyone can explain this ?
 

View Replies !

---

SQL Server 2000 Databases To SQL Server 2005? Enterprise Manager And Management Stuio At The Same Server?
When I proposed start to use SQL Server 2005 for new VS 2005 web sites, one of my co-workers responded that
we will update the old SQL Server 2000 databases to SQL Server 2005 when we are ready to use 2005 SQL Server.

Questions:
1. Any expected problems to upgrade old 2000 databases to new 2005 SQL Server?
2. I have installed both 2005/Management Studio Express and 2000/Enterprise Manager in my PC.  Any expected
    problems when running both 2000 and 2005 SQL Server at the same database server?
3.  What is the best configuration for running SQL Server 2005 when we have old 2000 databases?  Upgade or not upgrade?  

TIA,
Jeffrey

View Replies !

---

I Can No Longer Connect To My SQL Server Express 2005 From Manager Studio Express
Everything was working fine.  I have been able to connect using windows authentication.  Then, I went into the ODBC manager to add a data source and it failed to connect so I went back into the Server management studio to modify users.  After doing this I now get an error when I try to conenct the management studio to the SQL server.

I wasn't modifying the login for my windows account that I normally use, I was modifying a different one, however I now get the message "An error has occured while establishing a connection to the SQL server.  This kind of problem can ocure because the default behavior of the server does not support all connection methods" blah blah.

Does anyone know how I can attach to the server?  Or, do I need to somehow remove the server and create a new one?  How would I do that?

Thanks in advance for any input.

View Replies !

---

Using MS SQL Server 2005 Enterprise Manager With MS SQL Server 2000
Hi Everyone,Most of our MS SQL Servers are still running on SQL 2000, but being Iwill soon be upgrading my workstation to Vista Business I'd like toinstall MS SQL 2005 Enterprise Manager to manage them all. When Itried to install MS SQL 2000 Enterprise Manager on Vista, it gave me amessage saying it's not compatible, so I'll have to use 2005 I guess.We have LOTS of DTS scripts on our SQL 2000 server, and will 2005 EMwork with these okay? Also I want to make sure SQL 2005 EnterpriseManager won't be adding to, changing, or 'upgrading' the DTS scripts oranything on the SQL 2000 servers as we still have folks using SQL 2000Enterprise Manager.Thanks for any suggestions. I'm always leery when using cross-versionsof Microsoft applications because they are often incompatible or theydo squirly things that often break stuff.Thanks --Alex

View Replies !

---

Upgrade From SQL Server 2005 Express To 2005 Enterprise Fails
Hi

I am trying to upgrade SQL Server 2005 Express to SQL Server 2005 Enterprise Edition.
(As a Preparation to install SQLServer2005 Service Pack 2 (CTP))

I tried to upgrade a particular Instance (OFFICESERVERS, which was based on SQL Server 2005 Express ).

During the upgrade I get a message saying that ...

.....Your upgrade is blocked because of edition upgrade rules.....

All other components I selected for Installation are propertly installed (Analysis, Reporting)

The setup log contains the following detail information:

---- Context -----------------------------------------------
Setting status of unmanaged components and removing unmanaged resources

Error Code: 29543
MSI (s) (DC!C8) [13:57:26:265]: Product: Microsoft SQL Server 2005 -- Error 29543. Your upgrade is blocked. For more information about upgrade support, see the "Version and Edition Upgrades" and "Hardware and Software Requirements" topics in SQL Server 2005 Setup Help or SQL Server 2005 Books Online.
Edition check:
Your upgrade is blocked because of edition upgrade rules. For more information about edition upgrades, see the Version and Edition Upgrades topic in SQL Server 2005 Setup Help or SQL Server 2005 Books Online.

Error 29543. Your upgrade is blocked. For more information about upgrade support, see the "Version and Edition Upgrades" and "Hardware and Software Requirements" topics in SQL Server 2005 Setup Help or SQL Server 2005 Books Online.
Edition check:
Your upgrade is blocked because of edition upgrade rules. For more information about edition upgrades, see the Version and Edition Upgrades topic in SQL Server 2005 Setup Help or SQL Server 2005 Books Online.
<Func Name='SetCAContext'>
<EndFunc Name='SetCAContext' Return='T' GetLastError='0'>
Doing Action: ValidateUpgrade
PerfTime Start: ValidateUpgrade : Fri Dec 29 13:57:26 2006
<Func Name='ValidateUpgrade'>
<Func Name='updateFeatureSellection'>
        Error Code: 0x80077367 (29543)
Windows Error Text:   Source File Name: sqlcaupgradeproduct.cpp
Compiler Timestamp: Mon Sep 19 01:07:45 2005
     Function Name: sqls::UpgradeProduct::CanUpgrade
Source Line Number: 142

---- Context -----------------------------------------------

I also tried to explicitly upgrade the OFFICESERVERS instance by executing Setup from the command shell:

start /wait setup.exe  ADDLOCAL=SQL_Engine INSTANCENAME=OFFICESERVERS UPGRADE=SQL_Engine SKUU
PGRADE=1 /qb

The result is the same, i.e.... Your upgrade is blocked because of edition upgrade rules...

Does anybody know about this problem?
Some more information about the system:
W2K3 R2 Enterprise Edition
WSS3.0
MOSS2007
previously installed SQL Server 2005 Express Edition (Version 9.00.2047.00)

Kinde regards
Andreas

 

View Replies !

---

Can I Upgrade From Sql 2005 Express To Sql Server 2005 Enterprise Edition ?
if i upgrade from sql server 2005 expressto sql server 2005 enterprise can i do it ?
am i need to uninstall 2005 express before ?

View Replies !

---

SQL 2005 Express On Server 2k3 Enterprise
After a few failed installs I have gotten SQL2k5Exp installed.  I have update my .net and my XML.  I had the server running fine for about a week.  The server still 'runs' fine, but when I connect to it with Server managment studio express I can't do anything with it.  It will not allow me to expand the 'System Databases' It gives the error:

"Failed to retrieve data for this request. (Microsoft.SqlServer.Express.SmoEnum)

Additional information:

     An exception occured while executing a Transact-SQL statement or batch.

     (Microsoft.SqlServer.Express.ConnectionInfo)

          A transport-level error has occurred when receiving results from the server.  (provider: Shared Memory Provider, error: 0 - The pipe has been ended.) (Microsoft SQL Server, Error: 109) "

I get just about the same error if I try to attach a database, the only change is the error code at the end.

After this error the SQL server service stops.  I can restart it from the Services snap-in, but not inside SMSE.  It will start and stop if i try to start it in SMSE.

I also find these types of errors in my event log:

"SQL Server is not ready to accept new client connections; the connection has been closed. Wait a few minutes before trying again. If you have access to the error log, look for the informational message that indicates that SQL Server is ready before trying to connect again. [CLIENT: <local machine>]"

"The SQL Server (SQLEXPRESS) service terminated unexpectedly. It has done this 8 time(s)."

"The SQL Server Active Directory Helper service terminated with service-specific error 3221225572 (0xC0000064)."

Any ideas on this?

View Replies !

---

What Version: Enterprise Manager Or Management Studio Express
This may be a dumb question but I have searched and haven't found an answer to it here yet.

We are planing to get SQL Server 2005 for a specific purpose.We have several existing stand alone SQL Server 2000 database servers already. I have Enterprise Manager (2000) client installed on my PC. I recently installed SQL Server Express (2005) on my PC to get to know about new features.

I have run into problems (BCP specifically) with having two versions of C:Program FilesMicrosoft SQL Server80... and C:Program FilesMicrosoft SQL Server90... on my PC.

Is there any point before or after we purchase Standard version of SQL Server 2005 when I can do away with C:Program FilesMicrosoft SQL Server80... and/or uninstall Enterprise manager?

In other words can I manage SQL Server 2000 databases using only Management Studio(SQL Server 2005 client)? If not, how do I manage the two different versions of the client software on a single PC.

Thanks,

Dave K.

View Replies !

---

Cannot Upgrade SQL Server 2005 Express To SP2 After Upgrading SQL Server 2005 Enterprise To SP2
How do I upgrade Sql Server 2005 Express to SP2 if I also have SQL Server 2005 Enterprise SP2 already on the same box?  I installed Sql Server 2005 Enterprise first, then applied SP2, then installed Visual Studio 2008 (which installed SQL Server 2005 Express).
 
When I try to upgrade Sql Server 2005 Express to SP2 using the special Express edition of SP2, I get an error message that says "None of the selected features can be installed".  I end up having to cancel the install of SP2.
 
I'm left with SQL Server 2005 at level 9.0.3054  and SQL Server 2005 Express at 9.0.3042.  How can I bring SQL Server Express 2005 to the same level as SQL Server 2005 Entperprise?

View Replies !

---

Upgrading SQL Server 2005 Express To SQL Server 2005 Enterprise Edition
Hello!! How can I upgrade from SQL Server 2005 Express Edition to SQL Server 2005 Enterprise Edition? I see allot of example of upgrading from SQL Server 2000 to SQL Server 2005, but no example on upgrading from SQL Server 2005 Express to SQL Server 2005 Enterprise or Standard. Is this possible?

View Replies !

---

About SQL Server 2005 Express Manager
Hi all,
            Can anyone send me the working link from where i can downlaod and Install the free SQL Server 2005 Express Manager.

            Please send me valid link because i have fed up to surf so many links.

View Replies !

---

Help! Enterprise Manager Turns SQL Server Service Manager Off
IF someone can assist me.  Everytime I load up enterprise manager the service manager turns off.  And the enterprise manager can't connect to the local database.  But everytime i turn it back on and try to connect again it shuts it off and around and around we go.  Help would be appreciated.  Thanks.

View Replies !

---

Windows Server 2008 Enterprise &&amp; SQL Server 2005 Express Reporting Services
 

Does anyone know how to properly install SQL server 2005 express reporting services on windows server 2008. Whenever i try to access the report manager I get an error "Cannot access the remote server" even though the report server is on the local machine. I only have the web server role installed on the server. Im still quite a newbie at managing servers so please keep it as simple as possible.
Thanks
Matthew

View Replies !

---

Can SQL Server 2005 Express Edition Coexist With SQL Server 2000 Enterprise?
 

Not sure if this was posted but having a hard time finding an answer.
I'm currently running sql server 2000 enterprise edition on my machine and was wondering what would happen if i installed 2005 express edition and vice versa? I've found many blogs and post about compatibility issues with the 2005 Express Beta version but couldn't find any news with full version. It would be much appreciated if someone can help me out with this problem.
Thanks!

View Replies !

---

Migration From Sql Server Express 2005 To Sql Server 2000 Enterprise
hi, i need some help here,i made a simple data driven website in my development PC, at first, i used MS Access for my data base then i migrate it to sql server express 2005, and it works fine when i try to run it in my development PC with my IIS. but of course i will be deploying it to a real server, in our office were i will deploy my data driven site, we have a PC server Win Server 2003 with SQL Server 2000 Enterprise (im not pretty sure by the name but i know its not a free version, its something like a 2000 sql version with a word enterprise at the end).so my question is, i am developing an ASPdotNET site originally used SQL server 2005 express,how can i migrate my site to the Win Server 2003 and my database from SQL Server 2005 express to SQL server 2000 enterprisewill it work?? if not, what are the possible solution that i can do in cases like mine?i used Visual Web Developer 2008 Express Ed. in making my sites, and its DOES NOT allow databases in SQL Server 2000!!!!!it says "can't recognize the database"i hope you can help me with this.Thanks-SALAMAT PO....=) 

View Replies !

---

Where Is Enterprise Manager In SQL 2005
Ok I just installed VS 2005 Pro with that it asked me to install SQL 2005 and I said yes. Now I can't find the Enterprise Manager to create a database --weired-- All I see is configuration tools under SQL Server 2005. Am I missing something here? Thanks.

View Replies !

---

SQL 2005 -- Where Is Enterprise Manager?
I just downloaded SQL 2005 Enterprise Edition and I cannot find Enterprise Manager, which is a feature of SQL 2000. I do not know how to create a database, a table, etc without it. How do I do get enterprise manager.

Thanks.

View Replies !

---

Error After Installing Sql Server 2005 Express Edition Manager
Hey guys ! i have downloaded an installer of the sql server manager . installation works but when i run the manager i get this error : ( Its quite long so hold on to something )
file name is SQLServer2005_SSMSEE.msi
--------------------------------------------------

See the end of this message for details on invoking
just-in-time (JIT) debugging instead of this dialog box.

************** Exception Text **************
System.IO.IOException: Cannot create a stable subkey under a volatile parent key.

   at Microsoft.Win32.RegistryKey.Win32Error(Int32 errorCode, String str)
   at Microsoft.Win32.RegistryKey.CreateSubKey(String subkey, RegistryKeyPermissionCheck permissionCheck, RegistrySecurity registrySecurity)
   at Microsoft.Win32.RegistryKey.CreateSubKey(String subkey)
   at Microsoft.SqlServer.Management.UI.ConnectionDlg.RegisteredServersUtils.CreateKeyValueIfNotExist(String regPath, String keyName)
   at Microsoft.SqlServer.Management.UI.ConnectionDlg.RegisteredServersUtils.RegisterLocalInstancesIfFirstTimeUser()
   at Microsoft.SqlServer.Management.UI.ConnectionDlg.ConnectionDialog.OnLoad(EventArgs e)
   at System.Windows.Forms.Form.OnCreateControl()
   at System.Windows.Forms.Control.CreateControl(Boolean fIgnoreVisible)
   at System.Windows.Forms.Control.CreateControl()
   at System.Windows.Forms.Control.WmShowWindow(Message& m)
   at System.Windows.Forms.Control.WndProc(Message& m)
   at System.Windows.Forms.ScrollableControl.WndProc(Message& m)
   at System.Windows.Forms.ContainerControl.WndProc(Message& m)
   at System.Windows.Forms.Form.WmShowWindow(Message& m)
   at System.Windows.Forms.Form.WndProc(Message& m)
   at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
   at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
   at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)


************** Loaded Assemblies **************
mscorlib
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.42 (RTM.050727-4200)
    CodeBase: file:///C:/WINDOWS/Microsoft.NET/Framework/v2.0.50727/mscorlib.dll
----------------------------------------
Microsoft.SqlServer.Express.AppIDPackage
    Assembly Version: 9.0.242.0
    Win32 Version: 9.00.3042.00
    CodeBase: file:///C:/Program%20Files/Microsoft%20SQL%20Server/90/Tools/Binn/VSShell/Common7/IDE/Microsoft.SqlServer.Express.AppIDPackage.DLL
----------------------------------------
Microsoft.SqlServer.Express.VSIntegration
    Assembly Version: 9.0.242.0
    Win32 Version: 9.00.3042.00
    CodeBase: file:///C:/Program%20Files/Microsoft%20SQL%20Server/90/Tools/Binn/VSShell/Common7/IDE/Microsoft.SqlServer.Express.VSIntegration.DLL
----------------------------------------
System
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.42 (RTM.050727-4200)
    CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll
----------------------------------------
Microsoft.VisualStudio.Shell.Interop
    Assembly Version: 7.1.40304.0
    Win32 Version: 7.0.4054
    CodeBase: file:///C:/WINDOWS/assembly/GAC/Microsoft.VisualStudio.Shell.Interop/7.1.40304.0__b03f5f7f11d50a3a/Microsoft.VisualStudio.Shell.Interop.dll
----------------------------------------
Microsoft.VisualStudio.OLE.Interop
    Assembly Version: 7.1.40304.0
    Win32 Version: 7.0.4054
    CodeBase: file:///C:/WINDOWS/assembly/GAC/Microsoft.VisualStudio.OLE.Interop/7.1.40304.0__b03f5f7f11d50a3a/Microsoft.VisualStudio.OLE.Interop.dll
----------------------------------------
System.Windows.Forms
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.42 (RTM.050727-4200)
    CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Windows.Forms/2.0.0.0__b77a5c561934e089/System.Windows.Forms.dll
----------------------------------------
System.Drawing
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.42 (RTM.050727-4200)
    CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Drawing/2.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll
----------------------------------------
Microsoft.SqlServer.Express.SqlWorkbench.Interfaces
    Assembly Version: 9.0.242.0
    Win32 Version: 9.00.3042.00
    CodeBase: file:///C:/Program%20Files/Microsoft%20SQL%20Server/90/Tools/Binn/VSShell/Common7/IDE/Microsoft.SqlServer.Express.SqlWorkbench.Interfaces.DLL
----------------------------------------
Microsoft.SqlServer.Express.SqlTDiagM
    Assembly Version: 9.0.242.0
    Win32 Version: 9.00.3042.00
    CodeBase: file:///C:/Program%20Files/Microsoft%20SQL%20Server/90/Tools/Binn/VSShell/Common7/IDE/Microsoft.SqlServer.Express.SqlTDiagM.DLL
----------------------------------------
Microsoft.DataWarehouse.SQM
    Assembly Version: 9.0.242.0
    Win32 Version: 9.00.3042.00
    CodeBase: file:///C:/Program%20Files/Microsoft%20SQL%20Server/90/Tools/Binn/VSShell/Common7/IDE/Microsoft.DataWarehouse.SQM.DLL
----------------------------------------
Microsoft.SqlServer.Instapi
    Assembly Version: 9.0.242.0
    Win32 Version: 9.00.1399.00
    CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.SqlServer.Instapi/9.0.242.0__89845dcd8080cc91/Microsoft.SqlServer.Instapi.dll
----------------------------------------
Microsoft.VisualStudio.CommonIDE
    Assembly Version: 8.0.0.0
    Win32 Version: 8.0.50727.762
    CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.VisualStudio.CommonIDE/8.0.0.0__b03f5f7f11d50a3a/Microsoft.VisualStudio.CommonIDE.dll
----------------------------------------
Microsoft.SqlServer.Express.ObjectExplorer
    Assembly Version: 9.0.242.0
    Win32 Version: 9.00.3042.00
    CodeBase: file:///C:/Program%20Files/Microsoft%20SQL%20Server/90/Tools/Binn/VSShell/Common7/IDE/Microsoft.SqlServer.Express.ObjectExplorer.DLL
----------------------------------------
Microsoft.SqlServer.Express.SqlMgmt
    Assembly Version: 9.0.242.0
    Win32 Version: 9.00.3042.00
    CodeBase: file:///C:/Program%20Files/Microsoft%20SQL%20Server/90/Tools/Binn/VSShell/Common7/IDE/Microsoft.SqlServer.Express.SqlMgmt.DLL
----------------------------------------
Microsoft.SqlServer.Express.ConnectionDlg
    Assembly Version: 9.0.242.0
    Win32 Version: 9.00.3042.00
    CodeBase: file:///C:/Program%20Files/Microsoft%20SQL%20Server/90/Tools/Binn/VSShell/Common7/IDE/Microsoft.SqlServer.Express.ConnectionDlg.DLL
----------------------------------------
Microsoft.VisualStudio
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.42 built by: RTM
    CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.VisualStudio/2.0.0.0__b03f5f7f11d50a3a/Microsoft.VisualStudio.dll
----------------------------------------
Microsoft.VisualStudio.Shell
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.762 (SP.050727-7600)
    CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.VisualStudio.Shell/2.0.0.0__b03f5f7f11d50a3a/Microsoft.VisualStudio.Shell.dll
----------------------------------------
Microsoft.VisualStudio.Shell.Interop.8.0
    Assembly Version: 8.0.0.0
    Win32 Version: 8.0.50727.42 (RTM.050727-4200)
    CodeBase: file:///C:/WINDOWS/assembly/GAC/Microsoft.VisualStudio.Shell.Interop.8.0/8.0.0.0__b03f5f7f11d50a3a/Microsoft.VisualStudio.Shell.Interop.8.0.dll
----------------------------------------
System.Drawing.Design
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.42 (RTM.050727-4200)
    CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Drawing.Design/2.0.0.0__b03f5f7f11d50a3a/System.Drawing.Design.dll
----------------------------------------
Microsoft.VisualStudio.Designer.Interfaces
    Assembly Version: 1.0.5000.0
    Win32 Version: 1.1.4322.573
    CodeBase: file:///C:/WINDOWS/assembly/GAC/Microsoft.VisualStudio.Designer.Interfaces/1.0.5000.0__b03f5f7f11d50a3a/Microsoft.VisualStudio.Designer.Interfaces.dll
----------------------------------------
Microsoft.SqlServer.Express.RegSvrEnum
    Assembly Version: 9.0.242.0
    Win32 Version: 9.00.3042.00
    CodeBase: file:///C:/Program%20Files/Microsoft%20SQL%20Server/90/Tools/Binn/VSShell/Common7/IDE/Microsoft.SqlServer.Express.RegSvrEnum.DLL
----------------------------------------
Microsoft.SqlServer.Express.CustomControls
    Assembly Version: 9.0.242.0
    Win32 Version: 9.00.3042.00
    CodeBase: file:///C:/Program%20Files/Microsoft%20SQL%20Server/90/Tools/Binn/VSShell/Common7/IDE/Microsoft.SqlServer.Express.CustomControls.DLL
----------------------------------------
Microsoft.VisualStudio.TextManager.Interop
    Assembly Version: 7.1.40304.0
    Win32 Version: 7.0.4054
    CodeBase: file:///C:/WINDOWS/assembly/GAC/Microsoft.VisualStudio.TextManager.Interop/7.1.40304.0__b03f5f7f11d50a3a/Microsoft.VisualStudio.TextManager.Interop.dll
----------------------------------------
Accessibility
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.42 (RTM.050727-4200)
    CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/Accessibility/2.0.0.0__b03f5f7f11d50a3a/Accessibility.dll
----------------------------------------
System.Data
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.42 (RTM.050727-4200)
    CodeBase: file:///C:/WINDOWS/assembly/GAC_32/System.Data/2.0.0.0__b77a5c561934e089/System.Data.dll
----------------------------------------
Microsoft.SqlServer.Express.Smo
    Assembly Version: 9.0.242.0
    Win32 Version: 9.00.3042.00
    CodeBase: file:///C:/Program%20Files/Microsoft%20SQL%20Server/90/Tools/Binn/VSShell/Common7/IDE/Microsoft.SqlServer.Express.Smo.DLL
----------------------------------------
Microsoft.SqlServer.Express.SQLEditors
    Assembly Version: 9.0.242.0
    Win32 Version: 9.00.3042.00
    CodeBase: file:///C:/Program%20Files/Microsoft%20SQL%20Server/90/Tools/Binn/VSShell/Common7/IDE/Microsoft.SqlServer.Express.SQLEditors.DLL
----------------------------------------
Microsoft.SqlServer.Express.ConnectionInfo
    Assembly Version: 9.0.242.0
    Win32 Version: 9.00.3042.00
    CodeBase: file:///C:/Program%20Files/Microsoft%20SQL%20Server/90/Tools/Binn/VSShell/Common7/IDE/Microsoft.SqlServer.Express.ConnectionInfo.DLL
----------------------------------------
EnvDTE
    Assembly Version: 8.0.0.0
    Win32 Version: 8.0.50727.42 (RTM.050727-4200)
    CodeBase: file:///C:/WINDOWS/assembly/GAC/EnvDTE/8.0.0.0__b03f5f7f11d50a3a/EnvDTE.dll
----------------------------------------
Microsoft.SqlServer.Express.SqlEnum
    Assembly Version: 9.0.242.0
    Win32 Version: 9.00.3042.00
    CodeBase: file:///C:/Program%20Files/Microsoft%20SQL%20Server/90/Tools/Binn/VSShell/Common7/IDE/Microsoft.SqlServer.Express.SqlEnum.DLL
----------------------------------------
Microsoft.SqlServer.Express.Reports
    Assembly Version: 9.0.242.0
    Win32 Version: 9.00.3042.00
    CodeBase: file:///C:/Program%20Files/Microsoft%20SQL%20Server/90/Tools/Binn/VSShell/Common7/IDE/Microsoft.SqlServer.Express.Reports.DLL
----------------------------------------
Microsoft.NetEnterpriseServers.Express.ExceptionMessageBox
    Assembly Version: 9.0.242.0
    Win32 Version: 9.00.3042.00
    CodeBase: file:///C:/Program%20Files/Microsoft%20SQL%20Server/90/Tools/Binn/VSShell/Common7/IDE/Microsoft.NetEnterpriseServers.Express.ExceptionMessageBox.DLL
----------------------------------------
System.Xml
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.42 (RTM.050727-4200)
    CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Xml/2.0.0.0__b77a5c561934e089/System.Xml.dll
----------------------------------------

************** JIT Debugging **************
To enable just-in-time (JIT) debugging, the .config file for this
application or computer (machine.config) must have the
jitDebugging value set in the system.windows.forms section.
The application must also be compiled with debugging
enabled.

For example:

<configuration>
    <system.windows.forms jitDebugging="true" />
</configuration>

When JIT debugging is enabled, any unhandled exception
will be sent to the JIT debugger registered on the computer
rather than be handled by this dialog box.

---------------------------------------------------------

( i dont know where to post this... is there a microsoft staff that could read this thread ? ) or anyone who knows what this error is for ? thanks

View Replies !

---

What Happened To Enterprise Manager In SQL 2005?
I just go a new job where I work with Point of Sale machines and I'm having a hard time figuring SQL 2005 out. When I was in school we were taught using SQL 2000. Some of our POS (Point of Sale) machines are moving over to using SQL 2005 Express and I am having the hardest time figuring all this out. All be it I haven't use SQL in a good while but I still remember how to administer SQL 2000 with Enterprise manager. Am I missing something or what's the deal hear.

Any help would be much appreciated!

Best regards,

--Bob

Bob McQuay
ADI Business Solutions
bobm@adionline.com
Network Technician

View Replies !

---

SQL 2005 Developer Edition, Where Is Enterprise Manager?
I just installed SQl 2005 Developer Edition, and don't see an Enterprise Manager icon. Only Configuration Tool icons were installed.

 

Is this all SQL 2005 Developer is, or shoudl I be seeing an Enterprise Manager?

 

Thanks for your response,

 

Nate Terry

View Replies !

---

How To Restore Sql Express 2005 DB In Sql Express Enterprise Edition 2005
 

View Replies !

---

Setting Admin Rights To Report Manager, SQL Server Express 2005 On Vista Business
Hi all,

I'm a newbie to Reporting Services so please forgive my ignorance...

I've recently installed SQL Server Express 2005 with Reporting Services on my Vista Business Notebook (with no network connections) and have installed VS C# Express as well as the Business Intelligence Studio to create reports.

My C# application can connect to SQL Server fine, however, the reports I created with Business Studio refuses to deploy to the server due to the following reason:

"The permissions granted to user 'localhostJenny' are insufficient for
performing this operation".

I find this odd as I've been able to deploy reports on my other Windows XP machine (with SQL Server Express) no probs at all.  Additionally, I cannot see the 'Site settings' link within Report Manager (Web) that I'd normally get with an admin account (i.e. on my Win. XP machine).  Various sources indicate that my account has insufficient access rights to view this.

Having browsed through seemingly endless blogs and forums, I suspect that my local account has not been configured to access the Report Manager web client to publish, manage and administer the site.

I have tried the surface area tool for SQL Server, but I suspect that this is relevant only to SQL Server DB access and management.  Adding an administrator here does nothing.

The question is, how can I grant access to myself (local account) to allow me to publish reports via business studio, and at the same time - administer Report Manager Site Settings - on my vista notebook??

I would be extremely grateful for any help on this matter - I've tried ceaseless reinstallations, but to no avail!


Many thanks in advance,

Jenny

View Replies !

---

SQL Server Enterprise Manager
Does SQL Server Enterprise Manager and Query Analyzer come with the MSDE version of SQL Server 2000.

If it does, how do I open and access it?

If it doesn't, where can I download it from?

View Replies !

---

Where Is SQL Server Enterprise Manager?
I'm a newbie trying to find the SQL Server Enterprise Manager so I cancreate a database. I have installed SQL Server 2005 Express and SQL ServerManagement Studio Express. On the SQL Server menu I see (1) ConfigurationTools and (2) SQL Server Management Studio Express. The SQL ServerManagement Studio Express menu has 3 items on it. Where do I find theEnterprise Manager?Robert

View Replies !

---

Sql Server Enterprise Manager
What to I query in TSQL to check the transaction log size.... etc etc...
when the taskpad gives a javascript error.....

thanks,
Jonathan

View Replies !

---

SQL Server Enterprise Manager
Hi
I am encountering a rare situation with the following problem.
I have a DTS Package which calls couple of Stored procs to Truncate the tables and referesh the tables with new data. When I execute this DTS package (all by itself) it runs fine and populates the tables with 38000 rows. However when I execute this DTS package using the enterpise manager's Job Scheduler it says completed successfully but will have populated only 3000 rows.
(given the user rights are same for scheduler and for running DTS packages;
SQL Server: Version 7/ Windows NT Server 4/SQL Serevr Service Pack 3)

Any suggestions on why this problem could be occuring will be greatly appreciated.
Thanks in advance
Ajith

View Replies !

---

SQL Server Enterprise Manager.MSC
Does anyone know how to recreate the SQL Server Enterprise Manager.MSC file? It seems to have disappeared from the server. How can I open Enterprise Manager without it? I'm using NT4.0 and SQL Server 7.

Thanks,

Robert

View Replies !

---

SQL Server Enterprise Manager.MSC
I've managed somehow to corrupt the Enterprise Manager.MSC file
(it has ocurred several times), so it's impossible to open a table.
What can I do about it except re-installing the server?
What can be done to protect this file?

Thanks in advance.

Asnate

View Replies !

---

SQL Server 7.0 Enterprise Manager
I'm a newbie to Enterprise Manager so I appreciate any help.

Here's my question:

I have a SQL Server 7.0 account hosted by a webhosting company on a shared server. When I create a server registration and attempt to connect remotely to this database using Enterprise Manager, I get the following error:

Server user "john_sa' is not a valid user in database 'test123497'

The problem is that test123497 is NOT the database that they are hosting for me. I rechecked my Client Network Utility alias to make sure I'm connecting to the correct IP address and I double checked my username and password.

The server hosting this account is attempting to connect me to the wrong database. Sometimes I get through ok and other times I get the above error.

Is this because the hosting company has too many accounts on this server? Is the server running out of resources? Is there anything I can do remotely to control this?

Any answers would be greatly appreciated.

Thank you, john.

View Replies !

---

SQL Server Enterprise Manager
I am trying desparately to build a user defined function on the Microsoft SQL Server 2000 viewer and when it is performed I get the following message:

[Microsoft][ODB SQL Server Driver][SQL Server] Maximum stored procedure, function, trigger, or view nesting level exceeded

Is there any problem using sql MAX() built in function? How can I resolve this issue?

The UDF code is:
CREATE  FUNCTION TestFunc (@Syn int)
RETURNS  int AS  
BEGIN
IF @Syn IS NULL
    RETURN 1
DECLARE @NewPersonID INT
SELECT @NewPersonID = MAX(PersonID)
FROM GO_Test
WHERE SynagogueID = @Syn
RETURN ISNULL(@NewPersonID + 1, 1)
END


I call the function from the 'Formula' propery of a computed field of a table like this:
([dbo].[TestFunc]([SynagogueID]))

while SynagogueID is a field on the same table.

View Replies !

---

Sql Server Enterprise Manager
I have a AS400 that I retrieved data from and imported into SQL 2000 Server. However, the data will only insert 1 time. I would like to query the AS400 every minutes to update my table on SQL server. If the data is already in my table it does not get updated. How can I get updated/changed data every 15 minutes?

HELP!!!!!

Lisa Jefferson

View Replies !

---

Server Enterprise Manager
Why does the SQL Server Enterprise Manager seem to block other processes? I am working with SQL2000 developers version with SP4. When I set up a Data transformation service, it is not actioned until I close/open the Server Enterprise Manager. Otherwise it sits there as Process id 51 Master - runnable (this is the SEM) and Process id 52 - DTS sleeping.

Nigel
Phact

View Replies !

---

How Can I Connect To Microsoft SQL Server 2005 CTP With Microsoft SQL Server 2005 Express Manager?
I installed Microsoft SQL Server 2005 Express Manager and connect to SQL 2000 normally

View Replies !

---

Server Explorer (VS.NET) Vs. Enterprise Manager
Hello,I'm having the following dilemma: I'm trying to connect to a database on a SQL Server, somewhere else in the country. - With Server Explorer in VS.Net it is no problem at all. New dataconnection: i fill in the ip-adress, user and pass, and the database-name i want to connect to, and voila, it's done. I can add, edit, delete everything.- With enterprise manager: With enterprise manager i can make a connection with the server, but after that the database isn't visible. And as far as i know i can't connect to a certain database. Another option i tried is to create a linked server on my local server: that does work, only now i can't add/edit/delete..I really want to work with enterprise manager, but is there any way to connect to one db only, and still be able to add/edit/delete ?? I can't find the solution..Please help..Much regards..J.JansmaThe netherlands

View Replies !

---

SQL Server Enterprise Manager Access
How do I go about accessing the SQL Server Enterprise Manager to use DTS?
 
Robert

View Replies !

---

Can I Download The Enterprise Manager For SQL Server?
Hi,

I was wondering if I could download the Enterprise Manager for SQL Server. I am aware of some 3rd party tools but I want to use what comes w/ SQL Server.

View Replies !

---

Regd SQl Server Enterprise Manager
Hi,i would like to know - when we register a sql server (2000 in my case)in the enterprise manager from where does this information (name of theserver) come from? i.e where is this information stored ?thanks for the help.Regards,Shark.

View Replies !

---

Enterprise Manager Crashing SQL Server
Hi

We're having trouble with Enterprise manager when trying to view views or table data/properties, we get an access violation error and the database crashes sometimes corrupting tables.
Ive seen some posts stating a post SP3 for SQL Server is required and some posts saying client access should be modfied.
However our enterprise manager clients are registered with SA so I dont think that is an issue.
Can anyone give me some help with this and/or direct me to the hotfix please.

Cheers

Louise

View Replies !

---

Diagrams In SQL Server Enterprise Manager
Is there a way to export the diagram into another program or have another program open the diagram. I need to send a copy of it to someone and I have no idea how to do this with printing it out.

thanks ahead of time

View Replies !

---

Need Location Of MS SQL Server Enterprise Manager
I've looked on Microsoft.com for the download location for MS SQL Server Enterprise Manager and couldn't find it. Anyone know where it is?

View Replies !

---

Server Status In Enterprise Manager
I have 15+ servers registered and all but one display the current status of the server - i.e. running, stopped etc. Every time I expand the one server I get the error " the server is not known to be running..." if I answer yes to connect anyway, I'm able to connect and all seems well. What's causing this?

And yes, the client is setup to poll the server at 10 second intervals.

Thanks in advance.

View Replies !

---

SQL Server Enterprise Manager Error
when i try to view all rows of any of my tables through sql server enterprise manager i get the following error can anyone tell me why.An unexpected error happened during this operation [Query]-Query designer encountered a query error-unspecified error.I am using sql server 7.0.
Thanks
Ann

View Replies !

---

How Does Enterprise Manager Connect To SQL Server?
Can anyone tell me how Enterprise Manager connects to SQL Server? Does the Client Network Utility affect it? I can ping the servers with SQL on them, but I get timeouts and 'Connection Broken' in EM. Query Analyzer works sometimes and sometimes doesn't.

View Replies !

---