MS SQL Server :: Slow ADO Connection Speed Vista Vs XP To SQL2005 / Server 2003

Initial Slow Connection To SQL 2K5 On A Windows Server 2003 Machine
Hi,

I'm in the midst of trying to isolate a problem with my application: Here's the details:

- OS: Windows Server 2003 SP1 (+All security updates)
- DBMS: SQL Server 2005
- ASP web application + COM Components.
- All are located on the same server
- Using basic authentication
-

The application uses an ISAPI filter to grab image thumbnails from the database and send them back to the browser. If I log into the web app as a machine administrator, the thumbnails are returned quickly. If I log into the web app as a non-admin, there is a large delay before the thumbnails are returned. I've run the SQL profiler but it isn't showing me anything useful.
I've used all sorts of combinations for the connection string to the database, and all result in the same behaviour (Using different providers, etc.)

The funny thing is that the initial get of thumbnails takes a long time, but any subsequent runs results in the images returning immediately. If I restart IIS then the problem comes back.

Any thoughts on why an admin account would be fast and a non-admin slow?

Best Regards,
Greg.

ps. I hope this is in the right thread.

View Replies ! View Related

Slow Speed When Using Remote Connection In Enterprise Manager
Hi all

I am using enterprise manager for managing my database remotly
in this server there is about 60 Databases when I connect to database and when click on databases folder it take about 30 second to show me all of databases an my database

but some times its very slow and when i click on databases folder it will take about 20 minutes to show databases

whats the problem?

Thanks

View Replies ! View Related

Possible To Speed Up The Decision Tree By Clustering The Server 2003
Dear All,

I have a dataminig programming that need to run for days. Is it possibile to speed up the training process by clustering several server by Windows 2003 clustering services? Is it actually that clustering 2 QUAD core computer is almost giving comparable performance as the sum of the speed of two (There must be some overhead, I know). I am actually familiary with the use of clustering. Is it just for making the server farm more reliable or it will collaborate and speeed up the whole training process?

If it is, is there any limit on the number of cluster is in the cluster. What version of Windows and SQL Server do I need to achieve speed up of data mining training process?

Thanks and regards

Tony Chun Tung Siu

View Replies ! View Related

Deploying App To 2003 Server With SQL2005
I devloped this app with vs2005 and SQL 2005 express, everything seems to work fine, when I deploied the app to my web server I got a few different error messages that I worked through but now stuck on this one. i am sure it is something with SQL 2005 server. is there anywhere that has a good check list for doing things right in asp and SQL deployment?
here is the error message i am getting from debugging.
The SELECT permission was denied on the object 'Categories', database 'Blog', 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 SELECT permission was denied on the object 'Categories', database 'Blog', schema 'dbo'.
Source Error:
Line 33: SqlConnection connection = CreateConnection();Line 34: SqlCommand command = CreateCommand(connection, query, parameters);Line 35: SqlDataReader reader = command.ExecuteReader(CommandBehavior.CloseConnection);Line 36: Line 37: Type datatype = factory.GetDataType();
Source File: c:InetpublogplankroadApp_CodeUtilitiesSqlDatabase.cs Line: 35

View Replies ! View Related

Server 2003 Sql2005 Iis6
Have Server2003 Enterprise running IIS6 and sql2005. Lease is up and have to migrate to new server. Any migration tools out there to make this easier? Saw one for exchange, 2000-2003, but not one to do the server2003-server2003 and/or IISy-IIS6 and SQL2005-SQL2005. Any pointers for assistance?

thanks,
Janet

View Replies ! View Related

Upgraded SQL2000 To SQL2005, SQL2005 VERY Slow
I just upgraded my SQL 2000 server to SQL2005. I forked out all that money, and now it takes 4~5 seconds for a webpage to load. You can see for yourself. It's pathetic. When I ran SQL2000, i was getting instant results on any webpage. I can't find any tool to optimize the tables or databases. And when I used caused SQL Server to use 100% cpu and 500+MB of ram. I can't have this.Can anyone give me some tips as to why SQL 2005 is so slow?

View Replies ! View Related

Unable To Connect - SQL Express On Server 2003 From Vista
Getting error 1326.

I'm running SQL Express on Server 2003 SP1 (workstation - although, I did dcpromo promote and demote prior to installing SQL Express).

I'm trying to connect from SQL Studio Express on Vista.

TCP and Named Pipes are selected in Surface Area Config; sp_config remote, access..., 1 was run (per KB); ports 1433 & 1434 are open (I think 435 also was opened when I ran the KB instructions); Mixed mode is selected, user is set for SQL Auth, password is correct; all permissions are granted.

I found an article online which stated that mixed versions of MDAC can lead to the problem. The server has 2.82.1830 and the client has 6.0.5600.16834. Could this be the problem? If so, how to solve?

Thanks, John

View Replies ! View Related

Can't Connect To Local Server Instance MSSQLSERVER In SQL Server Management Studio (SQL2005 Sp2/Vista)
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 Replies ! View Related

MS Access Linked Tables To SQL Server 2000 Slow On Vista
I am using two almost idential laptops, one with XP and one with Vista, the only differences is that the XP laptop has 1G of RAM and running Office XP and the Vista has 2G RAM and is running Office 2007.

I have a MS Access database that has linked tables to a SQL Server 2000 database. The performance of the Access database on Vista is 5-10 times slower on the Vista machine. Just flipping through records or opening forms can take 5 - 15 seconds on the Vista machine while the XP machine takes 1 sec or less.

What gives? I looked at the CPU performance and the network performance while the Access database was busy flipping through records, the network traffic was < 2% and the CPU would spike to 40% on one of the CPUs (dual core) but would remain under 5% most of the time.

I also previously had Office XP installed on the Vista machine and it had the same performance issue so bought and install Office 2007 on the Vista machine and it did not solve the problem.

It seems that Vista is doing something that is slowing down Access with linked tables. Is this a issue between Vista and using an ODBC connection to SQL Server?

Thanks in advance for any help on this

View Replies ! View Related

Slow SQL 2005 X64 Standard Edition Performance On Windows Server 2003 X64
I am having major performance issues with Microsoft SQL 2005 x64 Standard Editions performance on Windows Server 2003 x64. The PC has two quad core cpu's with 8gb of ram and running a 500gb mirrored SCSI (Raid 1) drive system. The database running on the server is about 11gb. I've run a defrag several times which helps a little but I was hoping I could do something else to increase the performance.

I have also found that the bottle neck in the SSIS package is the backup and restore process of an 11gb database which takes about 1 hour (backup takes 1 hour and restore takes 1 hour) when it should take about 11 minutes. Is there anything I can do to make these processes run faster or to find out why they are taking so long? Any ideas would be a great help.

Thanks,

100011

View Replies ! View Related

Select Statement Is Very Slow - How Can I Speed This Up?
The following stored procedure is run whenever someone searches my database. When I first created the site, this search took less than 3 seconds. Now, there is more data in the system and the search is taking over 30 seconds.
I am not very good with SQL and I'm sure I am doing some dumb things. Is there a better way to write this query to speed things up?
Thanks a lot,
Chris MessineoSET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author:Chris Messineo
-- Create date: 4/27/2007
-- Description:Get Search
-- =============================================
ALTER PROCEDURE [dbo].[Search]
@Keyword as varchar(40)=NULL
AS
BEGIN
SELECT
Script.Title,
Script.ScriptID,
Script.Logline,
Member.Name
FROM
Script
Join Contest on (Script.ContestID=Contest.ContestID)
Join ScriptComment on (Script.ScriptID=ScriptComment.ScriptID)
Join Member on (Script.MemberID=Member.MemberID)
WHERE
(Title like '%' + COALESCE(@Keyword, Title) + '%' or
Logline like '%' + COALESCE(@Keyword, Logline) + '%' or
Comments like '%' + COALESCE(@Keyword, Comments) + '%')
GROUP BY
Script.Title,
Script.ScriptID,
Script.Logline,
Member.Name
ORDER BY
Title
END

View Replies ! View Related

How To Resolve An Indefinite Wait State On Update Command In SQL2005 (64bit 2003 Server)?
I am in the process of moving a SQL2000 database to a SQL2005 database.

Porting from: SQL200, Windows Server 2000(SP4) (32 bit dual processor)
to:SQL2005, Windows Server 2003(SP1) (x64 bit dual processor)

After porting the database from SQL2000 to SQL2005 (no changes) running the same update statement from Management Studio on the 2003 Server and and Query analiser on the 2000 Server.

SQL2000 completes the command in 2 minutes SQL2005 is still running after 60 minutes.

SQL2000 is the live/production system with users connected, the SQL2005 is in a test environment with no other processors running.

When the problem first showed up the SQL2005 activity monitor displayed CXPACKET wait type on 2 processes with the same pid number. I now no longer have any wait type being displayed but my wait time is increasing rapidly. No block is reported.

I assume that I have an CXPACKET lock problem.

Am I correct that I have a CXPACKET problem and if so what is the resolution?

The update statement is as follows...

update BI_LENDING_TRANSACTIONS
set [Balance Movement Month] = M.[Balance Movement Month]
from BI_LENDING_TRANSACTIONS as T,
     BI_BALANCE_MOVEMENT_DATES as M,
     BI_COMPANIES as C
where (T.[Transaction Date] >=
  (SELECT DATEADD(d, - 70, minDate) from (select min([Transaction Date]) minDate
   from p_BI_LENDING_TRANSACTIONS) t1)
  OR
T.[Transaction Date] >= C.[MostRecentSnapShotDate] or
T.[Value Date] = T.[Balance Movement Month] ) and
T.[Value Date] <= C.[MostRecentSnapShotDate] and
T.[Value Date] >= T.[Transaction Date] and
T.[Company_Code] = M.[Company_Code] and
T.[Value Date] > M.[SnapShotFromDate] and
T.[Value Date] <= M.[SnapShotToDate] and
C.[Company_Code] = M.[Company_Code]

View Replies ! View Related

Slow SQL 2005 64bit Standard Edition Performance On Windows Server 2003

Greetings,

We are having major performance issues with Microsoft SQL 2005 64bit Standard Editions performance on Windows Server 2003. We have an SSIS package running very slowly (and other sql tasks) on our two quad core cpu system with 8gb of ram and running a 500gb mirrored SCSI (Raid 1) drive system. The database running on the server is about 11gb.

Does anybody have any suggestion we could try to increase the performance of the server? I've run a defrag several times which helps a little but I was hoping I could do something else to increase the performance.

Thank you.

View Replies ! View Related

Outlook Runs Very Slow Frequently Non-response, SQL Server Using Up To 1GB Memory - VISTA && Office 2007
When I launch Outlook, it takes forever for the program to finally open. With any inbound email, it stops processing whatever is underway at the time....and frequently there is a 2-3 second lag between keyboard input and what appears on the screen. SQLserver is usually consuming upwards of 1-gb of memory....help. Mike

View Replies ! View Related

Large Database, Slow Query Speed. Help!
Hi guys,

I am asking this question on behalf of a friend. I have little knowledge of SQL 2005 but my friend is quite knowledgeable, although this is the first time he is dealing with large database for a client. So here's the story.

His client has a database containing 1.5 million books. Now he is setting up a website which will enable users to search books. Searching by ISBN is no problem as it only takes 1 seconds. The problem is, searching by Title takes more than 20seconds, which is unacceptable. My friend has only done smaller database and he just recently thought of implementing indexing and now looking for other ideas.

Each row contains book details such as Title, Author1, Author2, Author3, Publisher, Publication Date, ISBN, etc.

Can anyone who are more experienced in doing large database share with me some design ideas? His client is aiming for 8seconds or less.

Thanks in advance!

View Replies ! View Related

Â¿What Improves SQL Server Performance? HD Speed, Processor Speed Or Ram?

Hi,

I have several data bases on a server (SQL Server 2000 only, no web server installed) and lately, as the company keeps gowing, my users complain saying the server gets slow, (this dbs are well designed and recieve optimizations and integrity checks, etc) because of this, Im thinking about getting a new server to repleace my old ProLiant ML 330 which was bought 4 years ago but Im concerned about what server arquitecture or characteristic can help me best to improve response performance, is it HD speed? Processor speed? or more Ram? I want to make a good decision, so I´d really appreciate your help...

Thanks, Luis Luevano

View Replies ! View Related

SQL2005 Between Vista & XP
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 Replies ! View Related

None-Domain Server Cannot Access SQL2005 Data On Windows 2003 Domain Server
I'm trying to run a test from my test environment which is a non-domain Windows 2000 server to access my domain 2003 with SQL2005. I have install 2005 tools to try to access the SQL server.

- I have try following the KB265808 - no success.
- Reading alot of blogs and it seems all are pointing to the same problem. "Remote access" but the settign is enabled.Error Message:

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

Cannot connect to ardsqldatawh.

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

An error has occurred while establishing a connection to the server. 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: 40 - Could not open a connection to SQL Server) (Microsoft SQL Server, Error: 53)

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

Question: Could Windows 2003 security be blocking access? I'm using sa account to access.

Also, sa account does not seems to work for remote access. It is ok when accessing locally.

Any help would be appreciated.
949jc

View Replies ! View Related

32-bits SQL2005 On 64-bits 2003 Linked Server To Oracle 9 Problem
I am trying to setup linked server to Oracle 9.2 from a 32-bit SQL 2005 on a 64-bits 2003 server. just could not connect. have installed 32-bits 9.2 oracle client, and have installed 32-bits 10G oracle client, no success at all.. anyone is able to setup the linked server???

View Replies ! View Related

SQL Server Connection Error In Vista
Hi friends....

Plz help me out in the problem mentioned below....

Our server is Windows 2003...Sql server is SQL SERVER2000...I am trying to register this sql server from a local machine...It is showing the erroe

"SQL server registration failed because of the connection failuredisplayed below.Do you wish to register anyway?
SQL Server does not exist or access denied.
ConnectionOpen (Connect()) "

TCP/IP and Named Pipes are the enabled protocols in Both Server and Client network Utilities.

Local machine configuration is

OS- Windows vista Business...
SQL- SQL Server 2000 client

I am able to connect from other local machines which is having windows 2000 as OS.

Also I am able to register from the windows vista machine to another sql server which is having Windows 2000 OS. connection problem is only happening when I am trying to connect to Windows 2003 server.

Please help me as I am having urgency to resolve this.

Thanks in Advance

Sreejith

View Replies ! View Related

Can't Install SQL2005 Express In Vista
Hi

I'm trying to install sql express sp2 2005 in my laptop but i can't, give me this error

Machine         : W7J
Product         : Microsoft SQL Server 2005 Express Edition
Product Version : 9.2.3042.00
Install         : Failed
Log File        : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0015_W7J_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

I'm choosing Windows autentication mode, so i don't know it says "sa" user.

can you help me?

Thanks

View Replies ! View Related

Installing Sql2005 On Windows Vista
Hi,

Unfortunately I'm still running windows 2000 as my development box here, since I'm unable to install so many things now, I am forced to upgrade.

I'm wondering if I can run sql2005 on my new windows vista box if I get it ? I won't go ahead if I can't so its a pretty big deal :)

I'm reading mixed answers so far from googling. Thought it would be best to ask here!

thanks very much!
mike123

View Replies ! View Related

Slow Performance In SQL2005
Hi,We have shifted one of our data processing to a new instance of SQL2005. For this a new DB was created in SQL2005 and it is not anupgrade of SQL200 DB.The data processing application is a VB6 application that runs a batchprocess to insert about4.5 million records everyday in this SQL 2005 database. I am usingADO(ver 2.6) Connection object to execute T-SQL insert statements toinsert the 4.5 mill. records.This same application used to insert the data in the SQL 2000databaseand used to take about 2.5 hours to do so. After moving it to SQL2005 the performance has really detriorated and it now takes morethan6 hours.Is there any configuration change that I need to do in SQL 2005?Please help.Note: There is also an instance of SQL 2000 running in the sameserver.TIA,Tawfiq

View Replies ! View Related

Sql2005 Transaction Become Very Slow
Hello,

I've migrated an DB from SQL2000 to SQL2005, all it's working, but i've a "strange" problem, during the night, the transactions become very slow (no specific load) and if i restart service or I change the Degree of parallelims or Cost Threshold for parallelims to another value, it's solve the problem.

In the server logs (W2003) and SQL logs I can't see an warning or error...

In the old SQL 2000 server i've no problem...

If anybody can help me .. :-)

View Replies ! View Related

SQL Server 2005 Connection Error On Vista
Hi,

I have ASP.NET application which connectts to SQL Server 2005 on a server remotely. Everything was working fine untill I installed Vista on my laptop and ran the ASP.NET application. It throws following exception very often :

"System.Data.SqlClient.SqlException: An error has occurred while establishing a connection to the server. 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: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)"

This seems to be Vista specific problem because evrything works fine on XP machine.

Thanks

Mohit

View Replies ! View Related

Could Not Open A Connection To SQL Server Error On Vista
Hey,

After install Visual Studio 2005 (with SQL sever express) on recent Vista build, trying to connect to a local sse database file from Data Source Window (accessible from Data/Show data source window) gives this error:

---------------------------
Microsoft Visual Studio
---------------------------
An error has occurred while establishing a connection to the server. 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: 40 - Could not open a connection to SQL Server)
---------------------------
OK

No issues if we install Visual Studio 2005 on WinXP or W2k3.

Is there any configuration we need to set on vista to allow sql connection?

Thanks,

Mei

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

View Replies ! View Related

Problem Installing Either Sql2000 Or Sql2005 On Vista
i have a vista basic running on my lappy,i have beeen trying to install either sql2000 or sql2005 on it for the past one month i keep getting funny errors like installshield engine has stopped working.WHile on the sql2005 the installation will exclude the database mangament studio ,etc..I had disabled the norton antivirus running to no effect.

I really need help here!

View Replies ! View Related

Slow Connection To Sql Server 2005
I have a linked tables from access 2003 to sql server 2005 connected using odbc.

the connection is very slow.

when i use the same linked tables to sql server 2000 the connection is fine.

what seems to be the problem???

View Replies ! View Related

Slow Connection To SQL Server 2005
Hi!
I have a SQLServer 2005 running om a 64bit cluster. It is used to run a SharePoint 2007 portal. My problem is that the access to the database from the other servers in the farm is very slow.

I made a test program in C# that creates a standard .Net sqlConnection and runs a simple query 100 times. When run on the database server it takes less than a second, but when I run it from the web frontend server it takes 30 seconds. It never fails, it's just slow. The network connection is fast when copying files etc.

I see nothing out of the ordinary in the event log.

Do any of you have an idea what might be the problem or know how I could try to find the problem?

Thanks!

View Replies ! View Related

Intermittent Slow SQL2005 Database
I'm querying a small SQL2005 database and finding that the query can sometimes complete in under a second and then 5 minutes later the same query can take 15 minutes to complete.

The query I'm running is very simple as follows:
select TOP 26 * from vSearchListOpportunityItem WHERE OpIt_OpportunityId=2495 ORDER BY Prod_Name, OpIt_OpportunityItemId

The view it is pulling data from only contains only 1890 lines, which in turn pulls data from 3 tables with 821, 2560, and 1957 lines of data. In other words it's small. I have noticed that if I try and open the smallest of these tables while on a 'go slow' period it also takes around 15 minutes to return the data.

The database was originally on SQL 2000. It is the only database on this powerful quad core server.
The SQL Server CPU usage never goes above 40%, and always has free memory.
No sign of locks.

I can't figure out why such a small database is going so slow with such a simple query. Any ideas?

View Replies ! View Related

Add Connection In Server Explorer Won't Work In Vista Premium

Hello,

I'm trying to add a new connection in server explorer. The server will not appear
in the server drop down list, and when i manually type in the server and database name,
the connection fails saying

"An error has occured while establishing a connection to the server.
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: 40 - could not open a connection
to SQL Server)"

I made sure the remote connections were on, and I am having no problems open
the sql connection in code.

Thanks in advance,
Sharp_At_C

View Replies ! View Related

ODBC Connection To SQL Server 2005sp2 Installed On VISTA.
Hi people i am getting a problem when im creating a dsn to sonnect the SQL server as the database for my content server.....................i tried all the tricks given by you people but its still not workin it is showins a message that .............

Connection failed.

SQL State'01000'

[Microsoft][ ODBC SQL Server Driver][Named Pipes]Connection Open

(Connect()).

Connection Failed:

SQL State:'08001'

SQL Server Error:17

[Microsoft ][ODBC SQL Server Driver ][Named Pipes]SQL Server doe not exists or access denied............................

Please any body can help me out with this problem..............?

--------------------------------------------------------------------------------
Chetan

View Replies ! View Related

Connection From Acces 2003 To SQL Server 2005
What is the fastet connection between access 2003 to sql server 2005?

View Replies ! View Related

Errors Creating A SQL2005 Express SP2 Database Under Vista
Hi,

I'm trying to migrate a MSDE based application into a SQL2005 Express SP2 DB Engine on Windows Vista Business but I'm facing several errors that are blocking me.
Since the installation of SQL2005 Expr. must be done in a silent mode (the end user shouldn't set anything), I'm installing it using this syntax:

SQLEXPRSP2_ITA.EXE -q /norebootchk /qb reboot=ReallySuppress addlocal=all instancename=CSERV DISABLENETWORKPROTOCOLS=0 SQLBROWSERAUTOSTART=1 SQLACCOUNT="NT AUTHORITYSYSTEM" SQLBROWSERACCOUNT="NT AUTHORITYSYSTEM" AGTACCOUNT="NT AUTHORITYSYSTEM" ASACCOUNT="NT AUTHORITYSYSTEM" RSACCOUNT="NT AUTHORITYSYSTEM"

The installation proceeds without problems but when my program tries to create the database, a message error appears:

CREATE DATABASE denied on database 'master' (I translated directly from italian).
What I would like is to install SQL 2005 with "Windows Authentication" access instead of "SQL Authentication".

If I install SQL2005 manually by setting a named instance (CSERV), Windows Authentication mode, activating the option "set the local account as SQL administrative account" (translated from italian and suggested with Vista) I get the following error (read from the LOG):

CREATE FILE encountered operating system error 5 (access denied) while attempting to open or create the physical file 'C:Program FilesMicrosoft SQL ServerCSERVDataCGIDBDat.mdf'

CSERVData is the folder that the application creates and where the "mdf" and "ldf" files are stored.

So in the first case it seems that SQL2005 don't recognize the local account as administrator even if the user has administrative privileges (at least for Vista), in the second case is Vista that is blocking the action.

What is the solution??

Thank you and regards.

Roberto G.

View Replies ! View Related

Unable To Install SQL2005 I64 On A 2003 SP1 Itanium
Hello,

I have many problem when I try to install SQL 2005 Ets edition ia64 on a 2003 ets Itanium edition.

When I launch the setup, all is all right. But during the installation, it tryes to start MSSQL services.

The staring of this service failed. So I try to start the service mannually. Nothing.

Error messages I can get (in the event log) :

Source : Service Control Manager ; ID : 7000

Description :Service SQL Server (MSSQLSERVER) failed to start due to the following error: The service did not respond to the start or control request in a timely fashion.

Source : MsiInstaller ; ID 10005

Description : Product: Microsoft SQL Server 2005 (64 bits) -- Error 29503. Failure of the starting of service SQL Server. For more information, to see the headings of on line help €œProcedure: to post the files newspapers of installation of SQL Server 2005€? and €œmanual Starting of SQL Server€?. This error is (1053) The service did not respond to the start or control request in a timely fashion.

HELPPPPP PLEEEAAAASSEEEEEE !!!!!!!!!! ;-)

View Replies ! View Related

Access 2003 Projects Don't Work With SQL2005

Hi All,

Just installed a new version of SQL2005 on a brand new Application Server.

However, when i fired up Access 2003, it gives me some chaos about how Access isn't compatible with SQL2005. Fantastic lack of backward compatibility straight out the box.

Ok, so I do as it says and download all the updates.

Try again... Still won't allow me.

Wen't to Control Panel > Data Sources and confirmed the Native Client is in there. Added a System DSN for the new Server.

Tried Access again, still not working?? What the...

Why can't I create a new project in Access 2003, and edit it from my desktop instead of sitting on the server for every table modification? I hate designing tables on the SQL studio.

Any clues or help would be great. I'm just disappointed at the moment, on how this is holding up my database projects.

Thanks,

Chris.

View Replies ! View Related

Sql Server Express Slow Initial Connection
Hi,
I use a Remote Sql Server Express instance, and I have a strange behavior.. The first connection is really slow and I don't know how to fix that.I read some posts about this topic but I didn't find the right solution.Is there a way to "keep alive" the connection between my IIS server and the SQL one ?I check the auto-close property and it sets to false.
Any help ?
Stan

View Replies ! View Related

Slow ODBC Connection After Updateing To SQL Server
We have installed SQL 7.0 Client to connect to the SQL server 7.0. After installing the client (which updated all ODBC drivers) the database connections, even ODBC calls using MS access drivers become extremely slow. Any hints where to look?

View Replies ! View Related

Connection Failure To SQL Server 2000 In Remote Machine From Application In Windows Server 2003
Hi!!

I'moving my asp application to a new hosting server.

So when i tried the setup locally with the live DB & application in my test machine...
The DB access is denied when application tries to hit the DB.

DB is in seperate machine with SQL Server 2000 & application(ASP) is in Windows server 2003.....
Kindly help me with your suggestions....on what went wrong?

View Replies ! View Related

Very Slow And Not Complete Screen Update In SQL2005
Hi

I have the following problem (on 2 PC's now)

On 1 pc i installed VS2008 besides VS2005 and SQL 2005 (before i installed VS2008 everything was fine)

On the other is a fresh installed XP machine with only VS2008 SQL2550 and Office2007
Latets service packs are installed

On both machines when i open a table in SQL 2005 with the 'open table' command the show of the table is very slow.
Every row is updated file by field, the grid is not showing, the row and column headers are not 'grey' as normal.

Scrollign is impossible as the screen updates start again that slow.

Even a small table with 10 rows and 15 field behaves this slow. Its not workable.

What can be done to resove this???

Peter

View Replies ! View Related

Slow Performance When Executing Sql From A Vista Machine.
SQl server 2005 version: Microsoft SQL Server 2005 - 9.00.3054.00 (Intel X86)   Mar 23 2007 16:28:52   Copyright (c) 1988-2005 Microsoft Corporation Developer Edition on Windows NT 6.0 (Build 6000: ) .

Our customer has a SQL Server 2005 installed on a machine running Windows Vista.

Our application is running on a XP machine and on the Vista machine and its connected to the SQL server running on Windows Vista.
The customer table has 5498 records.

IF she runs the query "SELECT * FROM CUSTOMER WHERE dateadd(dd,0, datediff(dd,0,Lastupdated))>'20070101' ORDER BY [CustomerID]" using our application from the XP machine it takes a few seconds - 3 to 6 seconds.
If, instead, she runs the same query from the Vista machine it takes more than 5 minutes!!
This problem happens on every Vista machine.

We even installed the SQL Server 2005 on Windows Server 2003 but every time our application is run from a Vista machine this delay occurs.

The problem doesn't seem to be SQL SERver 2005 related because when we run from the XP machine everything is ok.
Maybe there is some problem with ADO (I even tested with the SQLNCLI provider: same bad results) or Vista...

We really need to solve this problem; the number of customers complaining about this behavior on Vista is growing.

NOTE: The LastUpdated column holds date + time info so we can't ignore the time part! I know, I know, bad design...

Thanks for your help.

P.S.:
We have just received another report from a customer that is running SQL Server 2000 on a Windows Server 2003 machine and using two machines (one Vista, one XP) to connect to the database.
Same behavior. Running the sql statement from the XP machine takes 3 to 6 seconds; on the Vista machine takes more than 5 minutes...

Thanks..
J.C.

Sample code:
Dim rsData As adodb.Recordset
    Set rsData = New adodb.Recordset
    rsData.CursorLocation = adUseClient
    rsData.Open "SELECT * FROM CUSTOMER WHERE ( CASE WHEN [LastUpdated] IS NULL THEN NULL ELSE CAST(CONVERT(char(10),[LastUpdated], 112) AS datetime) END > CAST('20070101' AS datetime)) ORDER BY [CustomerID]", mcnMainDatabase, adOpenStatic, adLockReadOnly
    rsData.Close

View Replies ! View Related

SQL2005 Developer Install On Windows Vista Home Premium
Hi, I'm having a problem installing SQL2005 Developer on Windows Vista.

At the System Configuration check page, I'm getting the IIS Feature Requirement item telling me IIS is not installed or disabled. This is not the case.

I have read article http://support.microsoft.com/kb/920201 and switched on the IIS components as specified.

I've tried installing with Firewall, virus checker etc switched off. Every time I get the same problem. This is an issue, as I specifically need Reporting Services installed.

Has anyone managed to solve this problem ?

View Replies ! View Related

Connection From XP SP2 To Windows 2003 R2 With SQL Server 2005 Failed
I cannot make named pipe connection with client by ODBC DSA.
Here is information. Refering to http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=362498&SiteID=1.
[1] Client side:
1.      What is the connection string in you app or DSN? (please specify) ODBC \[SERVER_NAME]pipesqlguery
2.      If client fails to connect, what is the client error messages? (please specify) Connection failed: SQLState: €™01000€™ SQL ServerError: 1326 [Microsoft][ODBC SQL Server Driver][Named Pipes]connectionOpen (Connect()) Connection failed: SQLState: €™08001€™ SQL Server Error: 17 [Microsoft][ODBC SQL Server Driver][Named Pipes]SQL Server does not exist or access denied.
3.      Is the client remote or local to the SQL server machine? [Remote | Local]
4.      Can you ping your server? [YES | NO ]
In cmd.exe console, type €œping -a <server_name>€?.
5.      Can you telnet to your SQL Server? [YES | NO, please specify the error message ]
In cmd.exe console, type €œtelnet <server name> port, where port can be 135, 445 or sql_server_tcp_port. If your cmd.exe console turns into a complete black screen with a cursor flushing on top left corner, you are connected. Type ctrl+€™[€˜ to bring up telnet prompt and type €œquit€? <enter>.
6.      What is your client database provider? [SNAC | MDAC | ADO.NET1.0 | ADO.NET2.0| other ODBC (please specify] Or/And, what is your client application? [SQL Management Studio | SQL Profiler | Visual Studio | Other (please specify).
7.      Is your client computer in the same domain as the Server computer? (Same domain | Different domains | WorkGroup)
8.      What protocol the client enabled? [Shared Memory | TCPIP | Named Pipes].
9.      Do you have aliases configured that match the server name portion of your connection string? If so, please check if it is correct. You can use cliconfg.exe (SS 2000) or SQL Server Configuration Manager (SS 2005) to configure the alias. [NO]
10. Do you select force encryption on server and/or client? [NO]

I was able to connect with TCP/IP settings.
[2] Server side:
1.      What is the MS SQL version? [SQL Server 2005]
2.      What is the SKU of MS SQL? [Enterprise | Standard | Workgroup | Express (or MSDE) | other (please specify)].
3.      What is the SQL Server Protocol enabled? [Shared Memory | TCPIP | Named Pipes ]. Use SQL Server Configuration Manager to configure it and check ERRORLOG or event log to confirm.
4.      Does the server start successfully? [YES | NO] If not what is the error messages in the SQL server ERRORLOG?
5.      If SQL Server is a named instance, is the SQL browser enabled? [YES | NO]
6.      What is the account that the SQL Server is running under?[Local System | Network Service | Domain Account]
7.      Do you make firewall exception for your SQL server TCP port if you want connect remotely through TCP provider? [YES | NO | not applicable | not enabled]
8.      Do you make firewall exception for SQL Browser UDP port 1434? In SQL2000, you still need to make firewall exception for UDP port 1434 in order to support named instance.[YES | NO | not applicable | not enabled]

I could connect locally with named pipes.
Do I have to make some file shares manually?
[2a] Tool Used to Connect
What tool or Application are you using to connect to SQL Server (eg: Visual Studio, SQL Server Management Studio, SQLCmd.exe, OSQL, etc) and especially the version of SQL Server (Express, Workgroup, Standard, Enterprise, Developer)
[3] Platform:
1.      What is the OS version? [Windows XPSP2 | Windows 2003 | Windows 2000 | Windows 98 | others (please specify ) ].
1.      Server [Windows Server 2003 R2]
2.      Client [Windows XP SP2]
2.      Do you have third party antivirus, anti-spareware software installed? [Symantec | Norton | other (please specify) ½ NO].

[4] Misc:
1.      If you have certificate configuration issue: Please use €œcertutil.exe €“v €“store my€? to dump certificate specific info and post it in your question. [NO]

View Replies ! View Related

DB Connection From Visual Studio 2003 To Sql Server 2005
I have one computer running Visual Studio 2003, and another running SQL Server 2005. I am trying (unsuccessfully) to add a connection to a sqlDataAdapter from an application in the Visual Studio 2003 computer to the db on the SQL 2005 machine.

If I go to the machine running sql 2005, where I am running visual Studio 2005, I can create this connection with no problems.

Is there a way fromvisual Studio 2003 to create a sqlDataAdapter with a connection to SQL 2005?

View Replies ! View Related

JDBC Connection Fails After Windows Server 2003 SP2
In testing new patches, I tried Windows 2003 Server SP2 and our JDBC connections stopped working. I uninstalled SP2 and they started working again. Anyone know where the problem is?

I have already read pages of documentation, but I will keep looking. Please let me know if you know the setting that needs to be changed. I'm assuming it is a new "security enhancement" but I'm just not sure exactly where.

Thanks in advance.

Hugh

View Replies ! View Related

BCP -- Insert Record Error (SQL2005-Window 2003)
Hi All,

When we to inset record into the tables through BCP we are getting following errors.

C:> bcp ACCT.dbo.dtpro out  C: estdtpro_TA.dat -T-n
C:>bcp ACCT.dbo.Semiaa out C: estSemiaa_TA.dat -T -n

BCP out works fine only BCP in have problems.

Please can you let me know how to resolved this problem.

===========
Exp - 1
===========

C:> bcp ACCT.dbo.dtpro in C: estdtpro_TA.dat -T-n

Starting copy...
SQLState = HY000, NativeError = 0
Error = [Microsoft][SQL Native Client]Unexpected EOF encountered in BCP data-file

0 rows copied.
Network packet size (bytes): 4096
Clock Time (ms.) Total     : 1

===========
Exp - 2
===========

C:>bcp ACCT.dbo.Semiaa in C: estSemiaa_TA.dat -T -n

Starting copy...
SQLState = HY000, NativeError = 0
Error = [Microsoft][SQL Native Client]Unexpected EOF encountered in BCP data-file

0 rows copied.
Network packet size (bytes): 4096
Clock Time (ms.) Total     : 1

============
Exp-3
============

C:>bcp ACCT.dbo.SemiH in C: estSemiH_TA.dat -T -n

Starting copy...SQLState = HY000, NativeError = 0
Error = [Microsoft][SQL Native Client]Unexpected EOF encountered in BCP data-file
SQLState = 42000, NativeError = 7339
Error = [Microsoft][SQL Native Client][SQL Server]OLE DB provider 'STREAM' for l
inked server '(null)' returned invalid data for column '[!BulkInsert].Created'.

BCP copy in failed

Thanks in Advance

View Replies ! View Related