Vista Local TCP/IP

Jul 19, 2007

Hi !

I've some problem with Vista and SQL Server 2005 SP2. My apllication (Client) can fast and correctly working on Sql Server on the other host and Client from other host can fast work when connect to my Sql Server, but when I'm connecting localy my apllication is working horrible slow :/ What should I change in Sql Server configuration or Vista to make my application run fast locally ? So cause only one difference (in my opinion) is how Client is connecting with Sql Server (other PC's by TCP/IP and locally can connect with other ways like named pipe or shared memory) I've disabled in Sql Server Configuration Manager all protocols except TCP/IP but it've changed anything :/ Can somebody help me ?

By the way sorry for my bad English

View 2 Replies


ADVERTISEMENT

SQL Connection In Vista With Trusted Connection Fails Under Local System Account Until Reboot

Mar 4, 2008

Hi All,

We are using the Windows Task Scheduler as a substitute for the SQL Server Agent, which isn't available in the Express edition. The scheduled task just calls a batch file, which in turn, runs a stored procedure using osql with the -E option for a Trusted Connection.

SQL Server Express has been installed using the defaults, which means the service is running in the "NT AUTHORITYNETWORK SERVICE" account. The scheduled task we create is set to run using the "NT AUTHORITYSYSTEM" account.

Now we find that on Windows Vista (tested using Ultimate Edition) that the scheduled task fails to run the stored procedure until the machine is rebooted the first time after installing SQL Server Express. When I say "fail", I mean that the stored procedure isn't executed. The scheduled task however completes and reports no errors. On Windows XP, we do not run into this problem so I suspect it has something to do with the UAC in Vista?

We further found that after installing SQL Server Express and creating the scheduled task in the "NT AUTHORITYNETWORK SERVICE" account, the scheduled task (and stored procedure) runs fine WITHOUT requiring a reboot.

Can anyone explain why a reboot is needed to get SQL Server Express to run the scheduled task correctly under Windows Vista and the SYSTEM account?

Any help or thoughts greatly appreciated.

View 2 Replies View Related

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

Apr 7, 2007

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



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

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



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

View 1 Replies View Related

Local SQL Server Instances Not Showing Up On Local Servers Tab Of Management Studio Logon Screen

Oct 2, 2007

We have a 64-bit VM server running SQL Server 2005. The SQL Server on this particular VM server has 6 local instances installed. On the Management Studio logon screen I can type the full name of the local instance and connect to it, however if I press the drop down in the Server name field, choose Browse and select the Local Servers tab there is nothing listed under Database Engines.

Any idea why the 6 local instances don't show up under Database Engines? This is preventing me from installing a vendor application because their installer looks for local SQL Server instances on this server, but if SQL Server won't even show the local instances then the installer doesn't see them either.

Any help is greatly appreciated.

Thanks,
Craig

View 3 Replies View Related

Not Able To Connect To The Local Database With (local) As Server Name

Jun 7, 2006

I am facing a problem in connecting to the local database with server name as (local).

I have installed SQL Server 2005 in my machine. When I try to connect to the SQL server with the server name as SUNILKUMAR I am able to connect but when I try to connect to the same server with the server name as (local) I am not able to connect. SUNILKUMAR is my machine name and SQL server is running locally.

if anyone can help me what is the problem in this case it is highly appriciated.

View 7 Replies View Related

Need Help - Local Synchronization Between SQL Mobile And Local SQL Database

Dec 21, 2005

Hi Everyone

I am at the stage of architecting my solution

My goal is to develop the system on a windows application and pda

There is a central server which will create a publication called inventory

The laptops which host the windows application will be subscribers to the central server using merge replication

The client now wants the PDA using SQL Mobile to synchronize with the local subscirber database on the laptop using active sync. They dont want to do it via WIFI to the IIS Server at the central server

I have been reading for days and I am still unsure whether this is possible to do.

I know Appforge provide a conduit for palm to access synchronization but not local sql databases

I would appreciate your help immensley

View 7 Replies View Related

Moving A SQL Server 2000 Database From A Local Drive To Another Local Drive

Jan 31, 2008

Being a very novice SQL Server administrator, I need to ask the experts a question.

How do I go about moving a database from 1 drive to another? The source drive (C is local to the server, but the target drive (E is on a Storage Area Network (SAN), although it is still a local drive for the server. I want to move the database from C: to E:. Can someone provide me with instructions?

Thanks,
Rick

View 4 Replies View Related

Failed To Generate A User Instance Of SQL Server Due To Failure In Retrieving The User's Local Application Data Path. Please Make Sure The User Has A Local User Profile On The Computer. The Connection Will Be Closed

Dec 7, 2006

This is my first time to deploy an asp.net2 web site. Everything is working fine on my local computer but when i published the web site on a remote computer i get the error "Failed to generate a user instance of SQL Server due to failure in retrieving the user's local application data path. Please make sure the user has a local user profile on the computer. The connection will be closed" (only in pages that try to access the database)
Help pleaseee

View 3 Replies View Related

Vista OS

Nov 7, 2007

I have purchased a seperate computer to "learn and play" which has Vista OS on it. What is the best/or most practical way to setup a sql db on this computer for me to play with and learn sql? I realize some of you think this may be simple but I don't have the opportunity to "dig" in the sandbox at work so I have to do this on my own. Thanks for your help.

View 1 Replies View Related

Vista 64 Bit

Dec 21, 2006

I am trying to develop using SQL Server Compact Edition on Vista 64-bit and when I try to load the .DLL files for x86 I get 'BadImageFormatException'. Looking at the documentation, I do not see where SQL Server Compact Edition supports Vista 64-bit, is this true? If it is true, when will it support 64-bit?



Luke Mauldin

View 4 Replies View Related

SQL && Vista

Jun 9, 2007

I'm having problems getting SQL Express running with Vista. It says remote connection may not be enabled when launching a program in the IDE. The application interfaces with a SQL database that was previously working in XP.



I have installed:

VS2005 Standard

SQL Express

VS Vista upgrade

VS2005 SP1

SQL SP2



Thanks.

View 2 Replies View Related

Vista && SQL

Apr 16, 2007

Hello, I have installed Vista Windows recently in my computer. And when using an application that connects a SQL Server2000 who is in the same dominion, gives the following error me:



[DBNETLIB][ConnectionOpen(Connect()).]

The connectivity between both pc's is correct.

View 1 Replies View Related

SQL Vista

Dec 20, 2007


I have Vista and Office 2007 installed. It comes with the SQL Configuration tool. I was told by someone at Microsoft that I can't install SQL 2005 server on Vista. I have an application called Goldmine that I want to run under Vista, using SQL.

Should I install SQL 2005 express? Can that work under Vista?

Can I use what comes with office 2007? What else will I need to download? Management Studio?

Thanks a ton,

Ken

View 13 Replies View Related

More Problems With SQl And Vista

May 15, 2008

I just added all users as Db_owner :) Now I am gettimg this error:
 
The EXECUTE permission was denied on the object 'GetCountryByISO', database 'zikbay', schema 'dbo'.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: System.Data.SqlClient.SqlException: The EXECUTE permission was denied on the object 'GetCountryByISO', database 'zikbay', schema 'dbo'.

View 3 Replies View Related

Vista Search

Feb 9, 2007

Hi

I'm trying to use Express to query the Vista Search engine using a linked server as follows:-

sp_addlinkedserver @server = 'myLinkedSvr', @provider = 'Search.CollatorDSO.1', @datasrc = 'SYSTEMINDEX', @srvproduct = '', @provstr='Application=Windows'
go
SELECT FileName FROM OPENQUERY("myLinkedSvr", 'SELECT Filename FROM SYSTEMINDEX')
go

but this returns

Server: Msg 7399, Level 16, State 1, Line 1
The OLE DB provider "Search.CollatorDSO.1" for linked server "myLinkedSvr" reported an error. Command was not prepared.
Server: Msg 7350, Level 16, State 1, Line 1
Cannot get the column information from OLE DB provider "Search.CollatorDSO.1" for linked server "myLinkedSvr".
OLE DB provider "Search.CollatorDSO.1" for linked server "myLinkedSvr" returned message "Command was not prepared.".

It's obviously "almost" working because it complains if I query a column that does not exist.

Any ideas?

tia
Niall

View 2 Replies View Related

SQL2005 Between Vista & XP

Aug 4, 2007

Hi
I have 2 computers
DESKTOP : runs WinXP and SQL Server 2005
NOTEBOOK : runs Windows Vista and SQL Server 2005

when i try to connect to DESKTOP from NOTEBOOK i get this error

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

Cannot connect to DESKTOP.

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

A connection was successfully established with the server, but then an error occurred during the pre-login handshake. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 0 - No process is on the other end of the pipe.) (Microsoft SQL Server, Error: 233)

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

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

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

can anyone help me to fix it?!

View 3 Replies View Related

SQL 2005 STD + Vista = Bad!

Nov 7, 2007

Experts... im completely stuck. My laptop was stolen, my replacement arrives with vista on it. Get my SQL Stuff on it and when I try executing a select statement on one of the sql servers I get the error; An error occurred while executing batch. Error message is: Internal connection fatal error. and it simply disconnects. I cant run any queries! Please help.

"Impossible is Nothing"

View 6 Replies View Related

SQL7 On WIN VISTA

Jan 13, 2008

Hello,

Can i install SQL7 on Windows Vista Home Premium Edition?

Appreciate any help.

Thanks,

Ed

View 1 Replies View Related

Issue With VB6 ADO On Vista

Jun 1, 2007

Hi,



I am having a vb6 application with sql server 2005 database. It works fine on windows xp. But when i install the application on windows vista I am getting Adodc error "login failed for user sa". Still the forms are populated with data from the database. But the event handlers dosent seem to work after i get this error. Does someone know what caused that adodc error. I have disabled User account control for the vista installation.



Vinith

View 4 Replies View Related

MSDN On Vista???

Aug 31, 2007

Hello,

I recently got me a new laptop with Vista preinstalled. All good and well, but when I try to install a program vital for my profession, I get an error (OS not supported for this program). In the install I can configure what components to install, one of them is MSDN 2000. My question is, will SQL Server Express take over what MSDN can't on Vista (and thus running the program needing the MSDN 2000), or will windows XP be the new OS on my brand new laptop in the future. Love Vista, hate the compatibility.

View 1 Replies View Related

ADOX And Vista

Dec 8, 2006

We€™re calling ADOX::Table::Keys::Append to make a primary key for a table using the SQLOLEDB provider. We€™re passing an ADOX::Key with Name set to a custom name, Type set to ADOX::adKeyPrimary, and a single column added. For the Append call, the 2nd parameter is ADOX::adKeyPrimary, the third is a vtMissing (VT_ERROR with DISP_E_PARAMNOTFOUND), the last two are empty BSTR€™s.
On XP, this works well (msadox.dll file version 2.81.1117.0). On Vista, this fails with an invalid parameter error (msadox.dll version 6.0.6000.16386).
Has the interface changed in some way, is this functionality not supported, or is it broken?

View 1 Replies View Related

SqlExpress And Vista

Nov 20, 2007

Hi, Mike, et al,

First of all, I am a self taught programmer, and a Sql Neophyte, and know just enough to get confused (or in trouble). I have a TabletPC app that uses SqlExpress, installing as 'Click Once'. Works great on XP, but my app comes to a screeching halt on Vista, because of the permissions/contact network administrator issue. I read Mike's post (dated a year ago, Oct 06) about using SSMSE to create a new Login with sysadmin rights for the current user. Long story short, completed it successfully, but it didn't work.

I have been browsing posts here on the subject, but I am confused. Does my Vista user need to install SP2? Will that fix the problem? I am sorry, but some of the posts on this subject are over my head.

Could I prevail on one of the moderators to point me in the right direction, or to explain in v-e-r-y b-a-s-i-c terms what I need to do to help my Vista users access my SqlExpress DB?

Many thanks!

Steve

View 11 Replies View Related

SQL 2005 On Vista

Aug 7, 2006

Has anyone managed to get SQL server 2005 standard edition working on Vista?

If I install from CD I get an error message

Error Message:

sql server setup could not connect to the database service for server confiurgration.The error was[Microsoft][SQL Native Client]Shared Memory Provider:No process is on the other end of pipe.

I have then tried installing SP1 (which i understand is meant to fix some of the vista issues), but then when I then try to re-install from the CD it says the version on my PC is more up-to-date and doesnt install.

All I have in Programs - SQL server 2005 - Are the Configuration tools, not the Management studio etc.

View 4 Replies View Related

Sqlexpress And Vista

Mar 3, 2007

I had sql express and microsoft express accounting working fine on xp. When I updated to vista and reinstalled sqlexpress with sp1 and management express sp1, I can not get the server to register. Any command I click gives error message "this type of initializer <module> threw and exception". Also when I tried to install accounting from office 2007 cd, will not install giving same message. Ihave uninstalled and reinstalled sql express w sp1 several times with no success. I can find no reference to this error message anywhere. Anybody got an idea where I can do to get this to work properly? Thanks in advance.

View 3 Replies View Related

SQL Server On Vista

Aug 14, 2007

Hello,
I am trying to install SQL Server Enterprise 2005 on Windows Vista Enterprise.
The installation has finished "successfully", but when I am trying to open the MS SQL manager, I see that the manager has not installed.

How can I fix it?
Thanks, Idan.

View 4 Replies View Related

Vista Error 500

Jun 9, 2007

Goodday

If I go to Http://localhost/reports I get this error

I have followed the tutorial but still get the error as below. If i go to http:// localhost I get the iis7 wecome page , without a problem.

Sorry I,m a bit new at this , I see in the error message that I must type something in a command line window.

Is this the black blackground box with C:windowssystem32>_ already typed in . Must I type this just after and press entre %systemroot%system32inetsrvAPPCMD.EXE migrate config "Default Web Site/Reports"







Server Error in Application "Default Web Site/Reports"


HTTP Error 500.0 - Internal Server Error

Description: This application is running in an application pool that uses the Integrated .NET mode. This is the preferred mode for running ASP.NET applications on the current and future version of IIS.

In this mode, the application should not specify ASP.NET handler mappings in the <system.web>/<httpHandlers> configuration section. Instead, it should use the <system.webServer>/<handlers> configuration section to configure ASP.NET handler mappings. You have the following options:
1) Migrate the application to work with the Integrated .NET mode (PREFERRED).You can migrate the application configuration, including the contents of the <httpHandlers> configuration section, by using the following from a command line window (the window must be running as Administrator):

%systemroot%system32inetsrvAPPCMD.EXE migrate config "Default Web Site/Reports"

After you migrate your application, it will run in both Classic and Integrated .NET modes, as well as on downlevel platforms.

View 13 Replies View Related

SQL Mobile And Vista

Apr 11, 2006

Are there any plans to support SQL Mobile running on Windows Vista? I have an application that runs SQL Mobile on Tablet PC's. I would like to support Vista the same way.

Thanks,
Joe

View 3 Replies View Related

Installation On Vista

Feb 26, 2007

Hi, I have a serious issue installing sql server express (advanced edition) on Windows Vista Home Premium. I'm doing the install with elevated priviledges but setup of the sql server always fails at the same point with the following error:

{Microsoft}{SQL Native Client}{SQL Server}Login failed for user 'sa'

I've tried many different combinations, including advanced installation options selecting sql server instance to run as local system or local server but nothing came out of that. I always select add current user to the sql server administrators group.
Any help on this issue is appreciated. Below follows the setup summary log:

Microsoft SQL Server 2005 9.00.3042.00
==============================
OS Version : Home Edition (Build 6000)
Time : Mon Feb 26 22:02:41 2007

Machine : JUPITER
Product : Microsoft SQL Server Setup Support Files (English)
Product Version : 9.00.3042.00
Install : Successful
Log File : c:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0007_JUPITER_SQLSupport_1.log
--------------------------------------------------------------------------------
Machine : JUPITER
Product : Microsoft SQL Server Native Client
Product Version : 9.00.3042.00
Install : Successful
Log File : c:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0007_JUPITER_SQLNCLI_1.log
--------------------------------------------------------------------------------
Machine : JUPITER
Product : Microsoft SQL Server VSS Writer
Product Version : 9.00.3042.00
Install : Successful
Log File : c:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0007_JUPITER_SqlWriter_1.log
--------------------------------------------------------------------------------
Machine : JUPITER
Product : SQL Server Database Services
Error : SQL Server Setup could not connect to the database service for server configuration. The error was: [Microsoft][SQL Native Client][SQL Server]Login failed for user 'sa'. Refer to server error logs and setup logs for more information. For details on how to view setup logs, see "How to View Setup Log Files" in SQL Server Books Online.
--------------------------------------------------------------------------------
Machine : JUPITER
Product : Microsoft SQL Server 2005 Express Edition
Product Version : 9.2.3042.00
Install : Failed
Log File : c:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0007_JUPITER_SQL.log
Last Action : InstallFinalize
Error String : SQL Server Setup could not connect to the database service for server configuration. The error was: {Microsoft}{SQL Native Client}{SQL Server}Login failed for user 'sa'. Refer to server error logs and setup logs for more information. For details on how to view setup logs, see "How to View Setup Log Files" in SQL Server Books Online.
Error Number : 29515
--------------------------------------------------------------------------------

SQL Server Setup failed. For more information, review the Setup log file in %ProgramFiles%Microsoft SQL Server90Setup BootstrapLOGSummary.txt.


Time : Mon Feb 26 22:30:02 2007

View 4 Replies View Related

Maybe It's Just Vista That Has The Problem?!?

Apr 23, 2007

So I installed a second instance of Report Server since the default instance couldn't find any default directories and I got this error message with started my saga Friday. I actually chose to follow MS's advise and do solution 1). That is when Report Server first lost track of it's directories and caused me to reinstall everything.



Does anyone know what this means?
Server Error in Application "Default Web Site/ReportServer$Two"


HTTP Error 500.0 - Internal Server Error

Description: This application is running in an application pool that uses the Integrated .NET mode. This is the preferred mode for running ASP.NET applications on the current and future version of IIS.

In this mode, the application should not specify ASP.NET handler mappings in the <system.web>/<httpHandlers> configuration section. Instead, it should use the <system.webServer>/<handlers> configuration section to configure ASP.NET handler mappings. You have the following options:
1) Migrate the application to work with the Integrated .NET mode (PREFERRED).You can migrate the application configuration, including the contents of the <httpHandlers> configuration section, by using the following from a command line window (the window must be running as Administrator):

%systemroot%system32inetsrvAPPCMD.EXE migrate config "Default Web Site/ReportServer$Two"

After you migrate your application, it will run in both Classic and Integrated .NET modes, as well as on downlevel platforms.
2) Move this application to an application pool using the Classic .NET mode.You can move the application to an application pool that uses the Classic .NET mode by using the following from a command line window (the window must be running as Administrator):

%systemroot%system32inetsrvAPPCMD.EXE set app "Default Web Site/ReportServer$Two" /applicationPool:"Classic .NET AppPool"

Alternatively, you can use any other application pool on your system that is running in the Classic .NET mode. You can also use the IIS Administration tool to move this application to another application pool.

It is preferred that you migrate this application by using option 1 to take advantage of the benefits provided by the Integrated .NET mode.

Error Code: 0x80070032

Notification: BeginRequest

Module: ConfigurationValidationModule

Requested URL: http://jc:80/ReportServer$Two

Physical Path: C:Program FilesMicrosoft SQL ServerMSSQL.6Reporting ServicesReportServer

Logon User: Not yet determined

Logon Method: Not yet determined

Handler: AboMapperCustom-43870

Most likely causes:

IIS received the request; however, an internal error occurred during the processing of the request. The root cause of this error depends on which module handles the request and what was happening in the worker process when this error occurred.
IIS was not able to access the web.config file for the Web site or application. This can occur if the NTFS permissions are set incorrectly.
IIS was not able to process configuration for the Web site or application.
The authenticated user does not have permission to use this DLL.
The request is mapped to a managed handler but the .NET Extensibility Feature is not installed.

What you can try:

Ensure that the NTFS permissions for the web.config file are correct and allow access to the Web server's machine account.
Check the event logs to see if any additional information was logged.
Verify the permissions for the DLL.
Install the .NET Extensibility feature if the request is mapped to a managed handler.
Create a tracing rule to track failed requests for this HTTP status code. For more information about creating a tracing rule for failed requests, click here.

More Information... This error means that there was a problem while processing the request. The request was received by the Web server, but during processing a fatal error occurred, causing the 500 error.

Microsoft Knowledge Base Articles:

294807

Server Version Information: Internet Information Services 7.0.

View 1 Replies View Related

Vista Install Help..

Feb 20, 2007

Ok ive tried looking everywhere for a solution but i just cant find one... please help me

I need to install SQL Server 2005 (for reporting services mainly) on Vista, but i have issues.

I have installed IIS and its checked in the pre-installation checklist, and the only thing with an exclamation point is the OS which is to be expected.

The issue im having is that when i get to the screen to select the features/components i want to install, they are all disabled apart from "Workstation components, Books online etc..."



Where am i going wrong with this.. I know i need the services pack to install reporting services, but i cant install anything at this point.

A walkthrough or something would really help...

P.S Im running on Vista Ultimate and trying to install SQL Server 2005 Enterprise.

Thanks!

Robert Macnair

View 6 Replies View Related

SqlExpress In Vista

Sep 10, 2007

Hi there,

I just installed a brand new Business Vista and moved my old databases from WinXP to this partition. Everything seemed to be OK for a couple of days but now I am getting some errors I cannot resolve. There is no online help for this topic.

Just a bit of background. I have to establish connections between my Sql Server databases and an MS Visual Management Studio 2005. I think the trouble began after I started doing connections this morning.

Before that did established connections between the two successfully but for various reasons I had to delete them, download the folder with databases anew and start from scratch. I do not quite remember what the trouble was but it was serious. I could not really use the connections in the VS.

When I began setting up connections today the Vista complained that I did not have permissions to access those files. OK, I went to the database folder and individually gave permissions to two groups I previously set up: Debugger & Microsoft Visual Studio. They both have the same users: me and administrator who is myself.

After that act I tried to open connections again (in VS). I got an error that user instances were disabled. It said: use sp_configure to enable user instances.

I went to Sql Server and tried to do just that. Before I could execute queries. Now I am getting errors even when I try to open a new query.

TITLE: Microsoft SQL Server Management Studio Express
------------------------------
Cannot show requested dialog.
------------------------------
ADDITIONAL INFORMATION:
Cannot show requested dialog. (Microsoft.SqlServer.Express.SqlMgmt)
------------------------------
Failed to retrieve data for this request. (Microsoft.SqlServer.Express.SqlManagerUI)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&LinkId=20476
------------------------------
Failed to connect to server DDMNVT61. (Microsoft.SqlServer.Express.ConnectionInfo)
------------------------------
A connection was successfully established with the server, but then an error occurred during the login process. (provider: Shared Memory Provider, error: 0 - No process is on the other end of the pipe.) (Microsoft SQL Server, Error: 233)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=233&LinkId=20476

OK, this thing appeared to have been resolved just a minute ago but I still decided to keep it here perhaps someone will comment on it because the way I resolved it was a total lack of understanding how I did it. Just clicked here and there and that was it.

Now need to resolve the user instances issue. I used sp_configure stored procedure in a query and got the result that the maximum number of user instances is 1. I do not know how I can change this parameter. I tried to use sp_configure with parameters with no good result.

If anyone know how to do it, please help.

Thanks.

P.S. I am sorry, that error has not been resolved. I keep getting it.

View 1 Replies View Related

Database Between XP/Vista

Feb 18, 2008

I created a database(about 800MB) on XP, I can open it on XP and WM5 without problem . But when I copy this file to Vista machine, I cannot open the file by my program. If I use SQL Server Management Studio to open it, it spends about 3 minutes+ to open it and the file increases about 150+ MB. Then I copy this file back to XP machine and try to open it, program takes long time to open it, just like it rewrites whole database. Is the database file not compatible between xp/vista? How can I create a file used on XP/Vista/WM5?

Thanks in advance.

View 4 Replies View Related

WSS On MSDE For Vista Or Later

Sep 27, 2006

Hi,

I have come to know that the upcoming OS releases VISTA, and Longhorn are no more going to (Courtesy: Microsoft Directions) support the MSDE version of the SQL. So, all the applications that are to be ported on to VISTA and are dependent on MSDE engine would first have the MSDE content be shifted to other compatible databases such as SQL Express, SQL Server (2k, 2k5).

If this is true, i'm wondering how Microsoft WSS release is going to be positioned from the Vista onwards as the typical install of WSS installs MSDE instance on the machine and add the configuration content on MSDE. That said, do we have to manually move our configuration databases to other compatible ones and let go with the functionality or if Microsoft has any plans of releasing any such tool that does this process automatically.

I appreciate your answers.

Regards,

Sagar

View 1 Replies View Related







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