MS SQL Server :: Can’t Make Vs2008pro, Sql2005dev, Sqlexpress All Work Together Via F5run And Vista Localhost At Same Time??

SQL Server Make ASP.net Load Slower At The First Time From Localhost.

Feb 16, 2004

I dont know if it's just a beginner issue.

My ASP.net project with database connection inside, I mean DataBound or whatever the name is make my website load slower because there's a delay about 8 til 9 seconds when in its first load from localhost, after the first load my ASP.net project run very fast and it just take 1 second or less to reload.
The problem will show up again after I restart my computer and trying to load my project from localhost at the first time.
How do I make my ASP.net project to load very fast with just 1 second or less at the first time from localhost?

Thanks.

View 1 Replies View Related

Can’t Get SQL Statement To Work

Feb 15, 2006

I’m using VB.NET to extract data from an Access database, simple enough. However, I type in the following line:

Sql = "SELECT * FROM [IPAddressList] WHERE [StartIPNo]>=" & IP_Address And "[EndIPNo]<=" & IP_Address

It doesn’t work.

If I type in:
Sql = "SELECT * FROM [IPAddressList] WHERE [StartIPNo]>=" & IP_Address
The above sql line works.

I now realize SQL commands is very sensitive.

FIELD NAMES:

quote:StartIP |EndIP|StartIPNo|EndIPNo|CountryCode
5.0.0.0 |5.163.66.79|83886080|94585423|ZA
5.163.66.80|5.163.66.95|94585424|94585439|SE
5.163.66.96|5.255.255.255|94585440|100663295|ZA
If the user types in a value, I want it to check the values between the StartIPNo and EndIPNo and return the CountryCode.

Any help would be appreciated

View 4 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

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

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

SQLEXPRESS And Vista

May 19, 2007

When I installed VS2005, a copy of SQLEXPRESS was also installed. It appears that it was installed using WIndows Authentication. It doesn't show up in Programs and Features or the VS2005 Setup so I can't remove it and install it using a userid and password. Is there a default userID and password that it was installed with?

View 1 Replies View Related

Vista And SQLExpress ADO/VB

May 5, 2007

I have an application that for the most part uses a local SQLExpress database, but might link to another server. The application has worked OK, and is is written in VB using ADO, and some DMO. I guess I lucked out prior to Vista, because I used the Builtin/User login and could create, attach, or alter existing databases. With Vista and UAC, I don't have the required privileges.

What can I do during an install (presumably as an administrator) to grant the required privilege to the builtin/user? Or shouldn't I be using the builtin/user?

Can I give the builtin/user "Create Database on Master" during an install, and then they would be able to create databases, when the app runs under a user?

Sorry for the ignorance - I'm pretty new to SQL and ADO.

Regards,

Howie

View 8 Replies View Related

Trying To Connect To SQLExpress On Vista

Apr 23, 2007

Hello !

I am trying to connect to a SQLExpress installed on Vista through the network.
I did enable all protocolls and in the Surface Area Configuration I activated Remote Connections ("using both TCP/IP and named pipes").
But still I get the following error:

"An error has occured while establishing a connection to the serveR. When connection to SQL Server 2005, this failure may be caused by the fact that uder the default settings SQL Server does not allow remote connections. (provider: SQL Network Interface, error: 26 - Error Locating Server/Instance Specified) (Microsoft SQL Server)"

Thanks a lot for any help!

Regards,
Fabianus

my favorit hoster is ASPnix : www.aspnix.com !

View 3 Replies View Related

SqlExpress Vista Troubles #3

Sep 13, 2007

This what happened in Vista. I just set up my SqlServer Express (SSMS), attached my databases: all of them except one.

The reason why it happened is that when I copied my folder with DBs from XP to Vista I found out that one mdf file was missing.There was the log file for that DB intact. It is a somewhat secondar database (at leas temporary until I will have resolved some tricky issues in C# app, then it will get full load). When I bagan chenging my conn strings in C# to accomodate new Vista's tastes I realized that that DB was not attached to VS 2005 either. I began to investigate.

I went to XP and checked thoroughly. First I thought this DB (mdf file for this DB) was stored in another partition. It does not seem to be the case. The entire disk was searched: nothing found.

The weird thing is: I can see this DB in SSMS in XP with ALL tables intact. I opened the design and also opened the tables. The values are all there. This is my first question: how can it be explained? Could it be that all the tables are in the log file for this DB?

So at this point I have no way to copy the DB from XP to Vista the way I did before with other DBs.

The next problem is this:

I went to Vista and tried to restore this DB from a backup. The backup may not be too fresh but I do not care. All I need is the structures and stored procedures. Vista gives me hard time.

This is my code:

RESTORE DATABASE [intraDay] FROM DISK = 'J:SqlServerBackUpsIntraDayintraDayFullRM.BAK' WITH RECOVERY,

TO 'C:intraDay.mdf'; -- this is just to try the RESTORE in principle. I will restore the DB to a different folder.

GO

I get an error that

Msg 156, Level 15, State 1, Line 2

Incorrect syntax near the keyword 'TO'.

I understand that the MOVE clause may be missing. I tried that but got in trouble with it as well.

Will appreciate any help.

I've never done RESTORE before.

Thanks.

View 3 Replies View Related

After Publish From VS2005 To IIS 5.1, SQLExpress Doesn't Work

Jan 30, 2007

I created an app in vs2005 and everything works perfectly in the development environment. I've published the site to my local IIS, but when I try to log in, it doesn't allow me. I'm assuming that it has something to do with the db not working correctly. Unfortunately I don't know how to debug to see where the problem is coming from now that it's running on my 'live' IIS. Does anyone have any ideas on what could be the problem. I have some settings in the web.config, which have been working perfectly.
<appSettings><add key="UserName" value=""/><add key="Password" value=""/><add key="Server" value="xxxxxxsqlexpress"/><add key="Database" value="xxxxx_xxx_users"/><add key="UseTrusted" value="True"/></appSettings>
I had a local guy at the office here saying that the ASP.NET user needs to be granted access to sqlexpress2005, but I wasn't sure on how to do that.
So all in all, My app works in Visual Studio 2005, and not in IIS. There are no errors when loading various pages. They all load correctly and without error. It seems that it's just when I try to do anything with the DB.
Thanks for the help. I appreciate it!

View 4 Replies View Related

How Do I Make It Work?

Jan 30, 2008

I have an OLAP database which is required to update daily. First of all back track a bit about this OLAP database, It is built from an OLAP data source consists of a dozen "Dimension" tables and half a dozen "Fact" tables and they are set up in a normalized relationship. This 20 or so OLAP tables are created from a single "Production" data warehouse de-normalized table. By the way the database engine, SSAS, SSRS and SSIS are installed in one virtual server using Sql 2005 SP2.

Here are the steps I update the OLAP database manually.

At Sql database engine

Drop the existing data warehouse table at the virtual server

Copy the up-todate data warehouse table from a remote server and paste to the database at the virtual server

Drop all the OLAP Fact tables

Drop all the OLAP Dimension tables

Create the Dimension Tables using the Sql script I saved when first created

Create the Fact Tables using the Sql script I saved when first created

Populate the data to the Dimension Tables from the data warehouse table using the Sql script I saved when first created

Populate the data to the Fact tables from the data warehouse table using the Sql script I saved when first created

Assign indexs and constrains to the Dimension Tables

Assign indexs and constrains to the Fact Tables
At Sql Server Analysis Services

Process the 15 Dimensions

Process the 2 OLAP cube
I want to automate the whole process using SSIS. I am new to SSIS and I need some direction on how to make it work?

Thanks

View 1 Replies View Related

Can't Seem To Make This Query Work

Jul 24, 2006

Hi,
I have a query thatI need to make into one query for the sake of an application reading only one cursor.

Here's the syntax:
select (select distinct(x.amount) from escrow k inner join e120 x on k.escrow = x.escrowinner join a10 g on x.escrow = g.escrow where k.ftype = 'S' group by x.amount, g.officer) As New,a.officer as Officer, count(distinct(j.fstatus))as Escrow_Type, count(distinct(j.amount))as Amount, count(distinct(d.open_date))as [Open], count(distinct(d.close_date)) as Closed, count(distinct(can_date))as Cancelled
from a10 a inner join escrow d on a.escrow = d.escrowinner join e120 j on j.escrow = d.escrow where j.id_scr = 'e21' and j.fstatus = 'PAID' group by a.officer

The error message i'm recieving is the following:

Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.

Any ideas? any suggestions would be great.

Thanks

View 3 Replies View Related

SQL Select - How To Make This One Work?

Aug 15, 2006

Select *From HSRSeasonWHERESeasonID='1'HSRID=(Select HSRID FROM HSR WHERE HotelID='1' AND ServiceID='1' AND RoomID='1')

View 1 Replies View Related

I Can't Make SqlBulkCopy Work

Feb 7, 2008

I have a scenario whereby I'd like to insert multiple rows into a table on a SQL server database as efficiently and easily as possible.
After some research, it looked like .NET 3.0's SqlBulkCopy class would do what I want. I've tried to set something up, but it's not working. It's not even throwing an error. The code executes but it simply hasn't done the insert by the end of it!
My table structure is simple. The name of the table is LPSTUnavailableDate. It has just two columns, one of them an auto-populated ID field:

LPSTUnavailableDateId, INT, PRIMARY KEY, IDENTITY(1,1)

View 1 Replies View Related

Vista Browser Error On Http://localhost/Reports - The Report Server Is Not Responding. Verify That The Report Server...

Apr 11, 2007

Hi -

I got through the installation hoops for SQLEXPRESS Reporting Services in Vista and set up the default configurations in Report Services Configuration. I can explore the default directory for "Reports" in IIS7, but I can't browse in IE. I get the "The report server is not responding. verify that the report server..." message in the browser. This is after I migrated the app per the initial http 500 error using the preferred method - %systemroot%system32inetservAPPCMD.exe migrate config "Default Web Site/Reports".

I'm running Vista Ultimate, VS2005, SQLEXPRESS SP2. I've tried running IE as admin and also I've disabled UAC from gpedit.msc - ...Windows SettingsSecurity SettingsLocal PolicySecurity Options and unchecking UAC.

Thanks,

Mike

View 13 Replies View Related

How To Make Two Separate Query Work Together

Oct 15, 2014

I am currently stuck on how to make this 2 separate query work together, both work as i want them to individually, please note the syntax is according to a application i use that uses mysql to manipulate columns in an imported csv file.

CONCAT('at-',
REPLACE([CSV_COL(18)],'http://www.homebuy.co.uk/product.php/','')
)
removes last character i.e. /
SUBSTRING([CSV_COL(18)], 1, CHAR_LENGTH([CSV_COL(18)]) - 1)

basically i need these 2 to work together to give me an output like this

at-09fd8903

from the this. URL...url above minus the "" as i said both work on there own, but not together.

View 1 Replies View Related

Can't Make This Update Work - Advice??

Feb 26, 2008

Hi - I'm in a situation with a very large table, and trying to run an update that, any way I've approached it so far, seems to be taking unnacceptably long to run. Table has about 20 million rows, looks something like this:

ID - int, identity
Type - varchar(50)
PurchaseNumber - varchar(50)
SalesAmount - Money

ID Type PurchaseNumber SalesAmount
1 A 3834AA38384 20.32$
2 B 3834AA38384 11837.32$
3 C 3834AA38384 666.32$
4 C 887DF88U01H 23423.32$
5 A 887DF88U01H 12.32$
6 B OI83999FH28 4747.1$
7 D 38438495985 9384.6
8 E 02939DDJJWI 22.22$
9 F 07939SDFDF2 33.33$

The goal of the update is to make the [Type] uniform across [PurchaseNumbers], according to the max sales amount. For each PurchaseNumber a, set the type = the type of the row that has the MAX salesAmount. If there is only one entry for PurchaseNumber, leave the type alone. Expected update after completion would look like this:

ID Type PurchaseNumber SalesAmount
1 B 3834AA38384 20.32$
2 B 3834AA38384 11837.32$
3 B 3834AA38384 666.32$
4 C 887DF88U01H 23423.32$
5 C 887DF88U01H 12.32$
6 B OI83999FH28 4747.1$
7 D 38438495985 9384.6
8 E 02939DDJJWI 22.22$
9 F 07939SDFDF2 33.33$

I got this out of a warehouse, and it definitely isn't normalized well. Was considering breaking down into a better model, but I'm not yet sure if that would make the update easier.

I've been approaching this with sub-queries (finding all the PurchaseNumbers with more then one entry, then the max sales purchase of that purchase Number, then the type of that purchase number and sales amount to update all of that purchase number) but this not only ends up a little messy, but also very slow.

The only other detail that may be important is that out of the 20 million total rows, about 19.5 million purchaseNumbers are unique. So, really, there are only about 500k rows I actually have to update.

I've thought of a few ways to make this work, but none of them seem fast and wanted to see if anyone had a pointer. Thanks!

View 5 Replies View Related

SQL Parameter And Wildcards, How To Make It Work?

Oct 22, 2007

Hello, I have what should be a very simple problem, but I cant solve it.
I want to have a stored procedure return a table query (no problems here) but I also need to supply several parameters to the stored procedure (again, no problem!)

Here is the problem, I need to be able to supply a wildcard into the stored procedure as an argument somehow. I can do this already, but the results are incorrect!!! It seems like when local variables are used, the wildcard argument gets ignored. for example, I have included the following example:

DECLARE @Dv_id nchar(15)

SET @Drv_id = '%'

SELECT Diver.*, (ROW_NUMBER() OVER(ORDER BY Dv_id)) as RowNum FROM Diver WHERE Dv_id LIKE @Dv_id

SELECT Diver.*, (ROW_NUMBER() OVER(ORDER BY Dv_id)) as RowNum FROM Diver WHERE Dv_id LIKE '%'

OK, this is an example of my problem, the results I get from this are that the fist SELECT return 0 rows.
The second SELECT returns the correct number of rows (everything in the table). Why is there a difference between:
WHERE Drv_id LIKE @Drv_id
and
WHERE Drv_id LIKE '%'
?
The wildcard statement '%' is supposed match everything, correct??
It seems like the local variable SET command syntax eats up my value of '%' and turns it into a NULL.

Is there any way around this?

View 2 Replies View Related

Trouble Getting RS To Work On Vista Business

Nov 7, 2007

I've just upgraded SQL 2005 Standard to Developer on Vista Business (actually had to uninstall whole SQL 2005 product in order for the upgrade process to work)

But it seems that RS didn't completely uninstall (the new install said it was still there).

I've reapplied SP2 and The DB Engine and SSAS seem to be fine - but unfortunately RS is now crippled.

I've re-attached the two RS databases - ReportServer and ReportServerTempDB

Everything looks OK in the RS Configuration Manager - the DB version is reported as C.0.8.54 in the Database Setup page, and all the options above are Green Ticked.

But when I try to browse to the ReportServer from IE (Started as Administrator) it gives "Server Application Unavailable"

The Application Error log says "A request mapped to aspnet_isapi.dll was made within an application pool running in Integrated .NET mode. Aspnet_isapi.dll can only be used when running in Classic .NET mode. Please either specify preCondition="ISAPImode" on the handler mapping to make it run only in application pools running in Classic .NET mode, or move the application to another application pool running in Classic .NET mode in order to use this handler mapping."

An earlier error from IE suggested running C:Windows>system32inetsrvAPPCMD.EXE migrate config "Default Web Site/ReportServer"
which was successful: "Successfully migrated section "system.web/httpHandlers"

Other than that I have changed nothing in the IIS setup from when RS was working fine.

When I try and connect to RS from SSMS it gives the error "

The report server cannot open a connection to the report server database. A connection to the database is required for all requests and processing. (rsReportServerDatabaseUnavailable) Get Online Help

Login failed for user 'NT AUTHORITYNETWORK SERVICE'.
"
I'm sufferring all this nightmare because I need semi-additive measures in SSAS for a customer demo I'm trying to prepare - which wasn't available in the Standard Edition.

I've already had to wipe Vista off my laptop once before - in order to completely uninstall RS - I'd rather not have to do it again if possible. (I've also tried going back to XP, but my nice fast new Dell Inspiron 1721 doesn't have any XP display drivers and Dell say they only support Vista on this machine!)

Any help on getting RS going on Vista - much appreciated!

Clive (London UK)

View 3 Replies View Related

MSSoap Running On Vista, Does It Work?

Jan 16, 2008

Hi,

Does anyone know if you can run MSSoap on a Windows Vista OS? reason being I have upgraded my laptop from Windows XP to Vista and now I cant get SOAP to work atall, where as on Windows XP I could.

Basically this is my typical install

Install SOAP Toolkit 3.0
Instal MSXML 4.0
Install RegLogEventDLLs
Register following DLLs:

C:Program FilesCommon FilesMSSoapBinariesMSSOAP30.dll
C:Program FilesCommon FilesMSSoapBinariesSOAPIS30.dll
C:Program FilesCommon FilesMSSoapBinariesWHSC30.dll
C:Program FilesCommon FilesMSSoapBinariesWISC30.dll
Register my SOAP Object DLLs
Configure IIS as follows:

Add ISAPI Extension .WSDL to use "C:Progra~1Common~1MSSoapBinariesSOAPIS30.dll"
if its a Windows 2003 server then I allow unknown ISAPI Extensions
Configure user credentials to run the SOAP Objects under Directory SecurityAuthentication
Setup Virtual Direcorys for each of my SOAP Objects
Restart IISThen with a bit of luck it all kinda works however under Windows Vista things are slightly different in that I cant find where to add the ISAPI Extension for the .WSDL or where to set user credentials to run my SOAP Objects.

When i use my test application to call one of my SOAP Objects I get a 5415 Timeout.

Has anyone got any ideas what i'm doing wrong or if i need to configure anything differently or install a newer version of the SOAPToolkit or anything?

Cheers
Steve

C:Program FilesCommon FilesMSSoapBinariesSOAPIS30.dll

View 4 Replies View Related

Does Sseutil Work Properly On Vista?

Mar 10, 2008

Does sseutil work properly on vista? I need a way to programmatically detach a user instance on Vista.
The following launches and runs ok on XP.
Doesn't run on Vista? Is there some problem with Process on Vista? sseutil runs ok from the command line in Vista.

public void DetachDatabase(string filePath)
{
ProcessStartInfo startInfo = new ProcessStartInfo("SSEUtil.exe");
startInfo.WindowStyle = ProcessWindowStyle.Normal; //.Hidden;
startInfo.Arguments = "-d "" + filePath + """;
Process detachProcess = Process.Start(startInfo);
while(!detachProcess.HasExited)
{
Thread.Sleep(1000);
}

}

View 5 Replies View Related

Error 26 - Followed The Guidelines, Still Unable To Make It Work

Nov 7, 2007

Good Morning, I've been searching through all the tutorials and questions, have tried many things. I am still getting "[SqlException (0x80131904): 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)]"

as an error. This is what I've got:

I��m using SQL Server Express 2005, installed with the default settings. Had not touched this program for anything until I started to follow directions to fix Error 26. Visual Web Developer Express ASP.NET is what I��ve used to build the webpage. I was using the ASP.NET web configuration to add users to the database, which is set to use the provider ASPSqlServerProvider.
SQL Server 2005 Surface Area Configuration
Database Engine Remote Connections �� set to ��Local and Remote Connections �� Using TCP/IP Only�?
SQL Server Browser is Enabled and Running
- is set to Active, under Built In Account �� Network Service
I have created Windows firewall exceptions for:
sqlservr.exe
sqlbrowser.exe
udp port 1434
SQL Server Configuration Manager
both SQL Server and SQL Server Browser are running.
Under SQL Server 2005 Network Configuration
Shared Memory and TCP/IP are enabled only.

SQL Native Client Configuration
Shared Memory 1
TCP/IP 2
Named Pipes 3
all enabled

I read through the post at http://blogs.msdn.com/sql_protocols/archive/2007/05/13/sql-network-interfaces-error-26-error-locating-server-instance-specified.aspx but as I'm new to SqlServer I do not know how to check on the first three items.

I'm getting extremely frustrated, and would just like the login portion of this website to start working before my boot ends up through the computer. Please help, lol, thank you.

View 9 Replies View Related

SqlServer 2005 Wont Work On Vista

Apr 4, 2007

hi,i have installed sqlserver 2005 on windows vista but it couldn't establish a connection with my computer. whats wrong with it? and i write my comp name to the server field which is located on the start window in mssql,

Please help me.Thanks..

View 18 Replies View Related

SQL Server 2005 Does Not Work After OS Upgrade To Vista

Jun 27, 2007

My instance of SQL Server Developer stopped working after upgrade of OS from Vista to XP. I have also installed SP1 & SP2. Still it is not working. The message that I get when I start SQL Server Management Studio is "The application cannot start."

View 7 Replies View Related

SQL Server Destination Doesn't Work On Vista?

Mar 19, 2007

All,

I have a package that works fine on XP. I copy it (and the databases used within it) to my new Vista Business Edition box (with SQL 05 SP2 with Hotfix.) Both the source and destination databases are on the 05 SP2 with Hotfix installation on this Windows Vista box (this is a completely local transformation.) The account I am logged in with is an Administrator on the box (and I have done the whole Vista provisioning deal.) Furthermore BUILTINAdmins is not disabled. Furthermore I went so far as giving this account every server role.

Short of it is when I use SQL Destination it fails - regardless of the options used. When I use an Ole Db Destination it works.

So, to prove that I am not crazy I recreated this package from scratch, and used a SQL Server Destination. The account I am using has essentially every permission imagineable. And to repeat: yes, I'm transferrring from a local database (on this box) to another database (on this box) and SSIS is running through BIDS on this box.

At this point I'm beginnning to think that it is broken on Vista, but I can't believe someone else hasn't run into this. However, when I look at the groups - nothing. Any ideas?

Thanks,

dcb99

View 1 Replies View Related

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

Feb 15, 2008

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 1 Replies View Related

10 Hours Of Hell -- Reporting Services Under Vista - Does It Work?

Feb 13, 2008

I have a brand-new Toshiba laptop, running Vista Business, that I installed SQL Express onto. Prior to installation, I was sure to install all the requisite IIS components so SSRS would install.

The installation ran fine -- installed all components. The configuration ran fine. Everything that is supposed to be green shows green

But, when I go to http://localhost/ReportServer, I get:

Server Error in Application "Default Web Site/ReportServer"

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

HTTP Error 404.2 - Not Found
Description: The page you are requesting cannot be served because of the ISAPI and CGI Restriction list settings on the Web server.

Error Code: 0x800704ec

Notification: ExecuteRequestHandler

Module: IsapiModule

Requested URL: http://localhost:80/ReportServer

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

Logon User: Anonymous

Logon Method: Anonymous

Handler: AboMapperCustom-34881

Most likely causes:

No handler mapping for this request was found. A feature may have to be installed.
The Web service extension for the requested resource is not enabled on the server.
The mapping for the extension points to the incorrect location.
The extension was misspelled in the browser or the Web server.
What you can try:

Install the feature that handles this request. For example, if you get this error for an .ASPX page, you may have to install ASP.NET via IIS setup.
Verify that the Web service extension requested is enabled on the server.
Open the IIS Manager and navigate to the server level.
In the Features view, double-click ISAPI and CGI Restrictions to verify that the Web service extension is set to Allowed.
If the extension is not in the list, click Add in the Actions pane.
In the Add ISAPI and CGI Restrictions dialog box, type the path of the .dll or .exe file in the ISAPI or CGI Path box, or click Browse to navigate to the location of the file.
In the Description box, type a brief description of the restriction.
(Optional) Check "Allow extension path to execute" to allow the restriction to run automatically. If you do not check this option, the restriction status is Not Allowed, which is the default. You can allow the restriction later by selecting it and clicking Allow on the Actions pane.
Click OK.
NOTE: Make sure that this Web service extension or CGI is needed for your Web server before adding it to the list.
Verify that the location of the extension is correct.
Verify that the URL for the extension is spelled correctly both in the browser and the Web server.
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 occurs when the necessary Web service extension is not enabled, the location or the name of the extension are misspelled or incorrectly entered.

--------------------------------------------------------------------------------
Server Version Information: Internet Information Services 7.0.

The only lead I could find when I googled this error was a reference to running appcmd to ensure that asp.net was enabled. It sure looks like it is:

C:WindowsSystem32inetsrv>appcmd list config -section:isapiCgiRestriction
<system.webServer>
<security>
<isapiCgiRestriction>
<add path="%windir%system32inetsrvasp.dll" allowed="true" groupId="ASP" description="Active Server Pages" />
<add path="%windir%Microsoft.NETFrameworkv2.0.50727aspnet_isapi.dll" allowed="true" groupId="ASP.NET v2.0.50727" description="ASP.NET v2.0.50727" />
</isapiCgiRestriction>
</security>
</system.webServer>

C:WindowsSystem32inetsrv>

Honestly... I'm out of ideas. I've been messing with this for 8 hours now, and I'm ready to fling the laptop out the window. I've completely UNinstalled SQL Server, IIS, reinstalled both, repeated the uninstall/reinstall after double-checking all files were deleted, and so on.

Does *anyone* know how to resolve this error? I checked IIS.NET and although they have a few references to it (not within the Reporting Services context) there never seems to be a definitive answer as to what the solution is.

View 17 Replies View Related

Transact SQL :: How To Make Procedure Work For Multiple Values In Parameter

Jun 7, 2015

Below is the stored procedure i have it works fine if i have 1 value passed to @invited_by but i want to modify but i want this code to be working for multiple inputs .Lets say if i do

exec [dbo].[sp_GetInvitationStatusTest] 'Test1 . I get the desired output but i want this procedure to work for
exec [dbo].[sp_GetInvitationStatusTest] 'Test1,Test2'.
USE [merck_acronyms]
GO

[code]....

View 2 Replies View Related

Linked Server Excel Import Doesn't Work In Vista

Jan 15, 2008

I was using linked servers to import Excel spreadsheets into SQL Server Express 2005. This worked fine with Windows XP and Office 2003.

I have just migrated all my stuff to Vista and Office 2007. Linked servers just can't be created:

TITLE: Microsoft SQL Server Management Studio Express
------------------------------
"The linked server has been created but failed a connection test. Do you want to keep the linked server?"
------------------------------
ADDITIONAL INFORMATION:
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.Express.ConnectionInfo)
------------------------------
Cannot initialize the data source object of OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "XXX".
OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "XXX" returned message "Unspecified error". (Microsoft SQL Server, Error: 7303)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.3042&EvtSrc=MSSQLServer&EvtID=7303&LinkId=20476
------------------------------
BUTTONS:
&Yes
&No
------------------------------

The parameter values I used are:

Provider: Microsoft Jet 4.0 OLE DB Provider
Product name: Excel
Data source: D:...somelocalfile.xls
Provider string: Excel 8.0

I gave full access rights to the Data source file and folder to NETWORK SERVICE and SQLServer2005MSSQLUser$MOZART$SQLEXPRESS where mozart is my PC name.

If I change Data source or Provider string to some garbage string, the exact same error message appears. So it appears the error might be in the Provider?

Help help please.

View 4 Replies View Related

SQL Server 2005 Installation Vista (+SP2), No Services, Doesnt Work

Nov 16, 2007

While installing SQL Server 2005 Enterprise Edition on Windows Vista Ultimate
the setup alerts me "there are known compatibility problems, please
install SP2 after this". So ok, all went nice and installed without error.
IIS 7 installed fully, so all green in setup display.
(But after installation i do not see any service which begins with SQL***...)
At the end, the setup wanted to start the administration Tool.
Ok, but my name was not listed, so i could not add me to the permitted users.
I can not use any tool, because i have no rights.

Some Ideas?

Microsoft SQL Server Management Studio 9.00.3042.00
Microsoft Analysis Services-Clienttools 2005.090.3042.00
Microsoft Data Access Components (MDAC) 6.0.6000.16386 (vista_rtm.061101-2205)
Microsoft MSXML 3.0 4.0 5.0 6.0
Microsoft Internet Explorer 7.0.6000.16546
Microsoft .NET Framework 2.0.50727.312
Betriebssystem 6.0.6000

thanks Frank

View 6 Replies View Related

Can't Connect From A Vista Client To SQL 2005 Box,other Machines Work Fine

Oct 27, 2006

Hey. I've a windows vista machine which can't connect to SQL 2005 box. Other machines which are lower than vista work fine. Also, vista box can connect to other SQL 2005 instances but can't connect to only one instance. But, I can connect to the instance fine from my XP box. Also, it's not a permissions issue. This user is an SA and can connect form some other machine. SQL 2005 box is at 2047 version right now. And, the user is able to connect to some other boxes which are also at 2047. Please help. Thank you

View 1 Replies View Related

If The Time Is Thus, Than Make The Timedate Thus

Dec 20, 2006

Here is an odd problem (to me).

I need to measure the time between timefield_a and timefield_b. So, I used
DATEDIFF (hh, timefield_a, timefield_b)

Now, they said "Our clock starts at 7am, so even if someone enters timefield_a at 5am or 630am, I want that rounded up to 7am, so my clock doesn't start till then".

So, I've been trying to create a case statement that rounds the time up to 7am but still keeps the date in tact. No luck.

Any thoughts?

View 1 Replies View Related