Looking For Mentor (service) For Help Designing Web Client For DB Access

Apr 24, 2008

I work at a place that does device testing where the test results are saved in a SQL database. I have an objective to create a plan for a pilot project to place the data on our intranet so our engineering dept can research test results.

I'm trying to find some group I can beg / borrow / pay to look at our schema and help me chart out what tools we should use and how much (ballpark) work is involved.

I'm a VB.NET developer. I did a tutorial on SQL Reporting Services and see potential there. I skimmed a tutorial on SQL Analysis services, and like the idea of being able to trend our data. But it's over my head at this point to get from where I'd like to be to what Microsoft tools to use and how to put them together.

I contacted one local DB/Developer shop and they wanted to bring in a team of engineers for two days and charge us $6000 for a "total solution". Instead of that, I'd like to maybe spend an hour on the phone and some emails to send a schema to someone who knew the tools inside/out and get a pretty good recommendation for a reasonable price.

Any ideas on how I can find such help?

thanks much - Mark

View 2 Replies


ADVERTISEMENT

SQL Server Client To WCF Service?

Apr 19, 2007

Is there any way to consume a WCF service from within SQL Server 2005? SQL CLR perhaps?

View 2 Replies View Related

Need To Install Service Pack On Client?

Jan 4, 2001

We are running SQL Server 7.0 on an NT Server in an NT environment. We have Service Pack 2 installed on the server hosting the database. Do we need the service pack installed on the client machines? Even if they only need client connectivity? Also does anyone know what fixes sp3 is supposed to fix? We are running our production environment without any known problems using sp2 and really dont want to disrupt it with sp3 if its not needed. Thanks in advance.

View 4 Replies View Related

Connecting To Reporting Service From Client

Apr 8, 2008

Hi Everyone,


I have configured reporting services to be connected from client with the help of http://msdn2.microsoft.com/en-us/library/ms365170.aspx KB article and I can connect locally in the server without any error. I've configured report service correctly since I can execute http://servername/reportserver or http://servername/reports . When I try to connect report service from my client Im getting the below error, can anyone help me to correct this.

Machine could not be found(Microsoft.sqlserver.management.UI.rsclient)


This is urgent since our developers are unable to connect from client

View 5 Replies View Related

How To Check Service Pack On Client Tool

Jan 14, 2008

How do i check if latest service pack in applied on client tool.
i have sql server 2005 clinet tool installed.

View 1 Replies View Related

Client Network Utility Service Pack

Jan 13, 2004

2 Questions:

1) I am getting back into SQL more than before, in my new job. I need to find the service pack installed on the clients who have the Client Network Utility installed. I do not remember how to do this.

2) Running 'Select @@VERSION' on the server returns 7.00.1063 but does not indicate the service pack. Does this still mean sp4 has been installed?

I'm trying to ensure we'll all up to date since our dual 700 procs are acting eratic...jumps between 10 - 95% or so.

Server info:

NT Server SP6
SQL 7.0
2GB Ram
2 procs @ 700Mhz
Roughly 80 network connections.
No other programs running on server except Antivirus.

Thank you!

View 3 Replies View Related

Does Service Pack 2 Affect Client Tools?

Jun 5, 2007

Hello,



Does Service Pack 2 affect client tools? In other words, if you have a client machine with just the tools installed (management studio, BIDS, etc) do I need to run the SP2 package on this client as well?



Regards, Jeroen

View 3 Replies View Related

SQLBrowser: Service Was Unable To Process A Client Request.

May 21, 2007

Hi, I have a Active/Active SQL 2005 Cluster, and I've seen this recurring message in the Event Log.


Source: SQLBrowser
Category: None
Type: Error
User: N/A
EventID: 8
Message: The SQLBrowser service was unable to process a client request.


I don't know if it's something to worry about, since I haven't had anyone call in an issue.


I have set the default and named instances to specific ports, no dynamic ports here.


There's nothing in the instances' error logs.

View 4 Replies View Related

How Can Client Get Service Pack Of Ssis Installed On Server?

Apr 12, 2008

if we installed ssis on the same server much later than the engine itself, could it have been installed successfully at an earlier service pack than the engine? I did a select @@version on the engine and got

Microsoft SQL Server 2005 - 9.00.1399.06 (Intel X86) Oct 14 2005 00:33:37 Copyright (c) 1988-2005 Microsoft Corporation Standard Edition on Windows NT 5.0 (Build 2195: Service Pack 4)

I cant see a way from the client to get a service pack on ssis itself. I'd like to be sure about a suggestion from one of your contributors before approaching our technical guys about their failure to install sp 2 of something.

View 3 Replies View Related

SQLServer 2005 Service Pack 2 Client Components Is Failing To Install

May 25, 2007

I have Windows XP Professional Version 2002 Service Pack2.

I Have:

Microsoft SQL Server Management Studio 9.00.2047.00
Microsoft Analysis Services Client Tools 2005.090.2047.00
Microsoft Data Access Components (MDAC) 2000.085.1117.00 (xpsp_sp2_rtm.040803-2158)
Microsoft MSXML 2.6 3.0 5.0 6.0
Microsoft Internet Explorer 7.0.5730.11
Microsoft .NET Framework 2.0.50727.42
Operating System 5.1.2600





Service Pack is failing to Install CLIENT COMPONENTS; message is:



Product : Client Components
Product Version (Previous): 2047
Product Version (Final) :
Status : Failure
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGHotfixSQLTools9_Hotfix_KB921896_sqlrun_tools.msp.log
Error Number : 29549
Error Description : MSP Error: 29549 Failed to install and configure assemblies c:Program FilesMicrosoft SQL Server90NotificationServices9.0.242Binmicrosoft.sqlserver.notificationservices.dll in the COM+ catalog. Error: -2147024894
Error message: The system cannot find the file specified.
Error description: Could not load file or assembly 'System.EnterpriseServices, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' or one of its dependencies. The system cannot find the file specified.



This situation, I am guessing, also preventing me to run import/export from the SQLServer Client.



Any help is appreciated. Thanks.

View 6 Replies View Related

Client Access Lisences

Dec 14, 2000

Hi,

My department has some questions about Client Access Lisences. Specifcally, they want a definition of what does and does not require a CAL,
and they want something somewhat official. I checked the MSKB, and looked on their sales website, but all I can find is the EULA, and that doesn't help
me all that much.

Does anyone else have this information?

Joe

View 2 Replies View Related

VERY Slow Client Access

Jan 28, 2002

I am experiencing VERY slow connectivity between client and server SQL 2000. I have checked the network activity and it is low. It also takes Enterprise manager ages to load, and then browsing tables and trees is impossible!

HELP!!

View 1 Replies View Related

Access Client Problem

May 9, 2001

Hello everybody,



I recently made a DTS-package from importing external data in my sql2k
server.
I linked my access file to the sql server to make some reports.

Right now, my clients run the dtsrun utility through a batch file
themselves. I gave them permissions to be the dbase owner.

Now when you link from access to sql server as admin, your names are :
dbo_Tablename.
If it's another user, the names get pvanmoer_Tablename and for another user
it's cvanho_Tablename.
(Validation through NT)
So my linked tablenames aren't valid anymore in my access file. So I need
to relink them each time.

How can I avoid this problem ? I've been trying to create tables without
dbaseowner, but this doesn't seem to work.

Can anyone help me ?

Thanks,


Bjorn

View 2 Replies View Related

Restrict Client Access

May 27, 2005

Hello Everybody,

I need some help.
When we install the Database at the clients end, the client can see all
the SQL tables, views and stored procedure in the Enterprise Manager.
Is there a way via which you can restrict the client from viewing the
tables in SQL Enterprise manager?

I hope you understand my question.
I would be oblidged if my friends could help me...

Thanks

View 1 Replies View Related

Refresh Access Client

Nov 18, 2005

Is there a way to update data on a MS Access 2000 client from SQL Server without polling a table using the form's onTimer event?

It would be much more elegant if I could push the data to the clients every 15-30 minutes when the data on SQL Server gets refreshed.

Can DTS do this? The forms I'm talking about are select only, no editing.

I know I can do this with java and multicasting, should work with MM Flash as well with listeners. I would really like to take this app to Flash, but we have a 1 month timeline to port from Access to SQL Server.

Thanks,
Carl

View 5 Replies View Related

Question Regarding Client Access

Jan 21, 2008

Hi,
We're *very* new to using SQL Server and are just getting it up and running. We're only running simple queries right now, but we're doing so by connecting to our server via 'Remote Desktop' to run the management studio to run the queries.

Is there an SQL client that can be installed on a user's workstation that will allow them to run queries without having to use a 'Remote Desktop' connection on the server?



Thanks,
James

View 3 Replies View Related

How Do I Allow Access To SQL Server On A Different NT Domain From The Client?

Jul 6, 2001

I want to give a client access to a SQL Server 7 database sitting on a different NT domain without setting up a trust relationship between the two domains. Has anyone tried doing this?

View 2 Replies View Related

DTS Scheduling OLE Db Error - DB2 Client Access

Feb 13, 2000

I have a DTS package that executes when run manually. It is a OLEdb (ODBC) to client access (db2). When I try to schedule it the package fails.

Other packages SQL - SQL are fine to schedule or to run man.

I have played with the Persist Security Info advanced properties of the connection to no avail.

Any assistance would be great.

Thanks

Robb M Sinclair
Newcomp Solutions Inc

View 2 Replies View Related

SQL2000 Vs SQL6.5 Client Access

Sep 18, 2001

I'm thinking to upgrade SQL6.5 DB to SQL 2000 but do not know
all client access with SQL 6.5 utility will work ???
(The application is a vendor canned package using SQL 7.0 DB
but client can access with 6.5 ---Not using ODBC)
Any experts can help ?
Thank you in advance !!

Lewis

View 1 Replies View Related

T-SQL (SS2K8) :: Cannot Access Server From Client App?

Jan 26, 2015

I have a C# windows app trying to access database based the connection string stored in teh app.config file

Here is my app.config parameters

<?xml version="1.0" encoding="utf-8" ?>
<configuration>
<connectionStrings>
<add name="con1" connectionString="data Source=127.0.0.1sinclair;initial catalog=kingsroad;uid=balrock;pwd=123456;integrated security=True" />

</connectionStrings>
</configuration>

The reason I want to put an ip address on connection string i just want to create connection strings as people do in their work. When the app tried access the connection string it gives the error in the attachment.

Because I haven't used this user/password for a long time I'm pretty sure the user name and password is correct but i have the following questions

1. Assume the user and password is incorrect, is there way to reset this?
2. what other configuration that i need to do in order to make teh C# app access this Database?

View 2 Replies View Related

Client Able To Access SSAS Cube Only Once

Sep 6, 2007

I have an excel workbook, that has a pivot table in it where the data source is an OLAP cube. My problem occurs on the client machine, logged in as the client. I remote into the PC, and create a pivot table using the OLAP cube connection. I create the pivot table and everything works fine - I am able to browse the data with no issues. Once I exit the Excel Workbook, and come back in - I am no longer able to connect to the datasource. I have tried both saving the password in the connection and not saving it. It has made no difference.

View 1 Replies View Related

SQL Server 2005 Client Access

Jan 24, 2008

Hi there

If I give the user access dbo on 1 of the database, when he logon using SQL Server Management Studio for running query etc, can he only see his database instead of other as well system database?

Is there any best practise in term of setting the SQL client for 2005?

Thanks

View 2 Replies View Related

Access A Database From A Client Application

Oct 18, 2006

Hi all...

I am writing a Windows Application which will be used by about 100 clients. (NT Authenticated)

The application is going to be used in a LAN enviroment. User who have access will download a VB.NET application from a web site.

Of course, I want to prevent any of the 100 users from using a tool such as Query Analysis or ODBC to connect directly to the database and modify data.

So, it appears the way to go is to the "Application Roles". For this to work, the application roll password has to be saved in the application to execute the sp_setapprole procedure.

Is there a way to secure this password? I am worried about a user somehow extracting the password from the application and connecting directly.

Am I on the right track here? Any ideas appreciated!

Thanks,

Forch

View 4 Replies View Related

Unable To Access MSSQLSERVER From Client

Dec 20, 2005

Hi,

I have SQL Server 2005 installed and functioning (it does everything I've asked it to do locally). I also have the Express and Standard Editions installed on a computer running WinXPPro SP2 with all the WinUpdates applied. I also have VS2005 installed on this computer. I've done some development work on this computer, using VS2005 to create a SQLDB, connect to it, add data, etc. This is all okay.

The problem is I cannot connect to the SQL Server from the client computer. I installed the client tools on this XP Pro box along with all the WinUpdates. Here's what I can do...

I can ping the SQL Server by name (the name gets resolved).
I can copy files between the two computers using Explorer.
I enabled "Allow remote connections to this server" in the Server Properties / Connections page.
I did not change the default port of 1433.
The TCP/IP protocal is enabled in the Configuration Manager.
The Surface Area has been configured to allow local and remote connections using TCP/IP and named pipes.
SQLBrowser surface is running as is the MSSQLSERVER service.

So what's going on? I am new to SQL Server to it may be something very simple / obvious.

Thanks for your help,
Scott

 

View 4 Replies View Related

Error: Login Failed For User ... Microsoft Sql Native Client . In Remote Connection On Integration Service

Apr 10, 2007

Hi



i connect to remote Integration Service. i configure server for remote connection( on component services and DCOM config , ... ) .and now i can connect to Integration Service remotely and correctly.



but when i expand Stored Package and then click to expand MSDB this error will hapen:

login failed for user ... .(microsoft sql native client )



please help me



thanks in advance

View 1 Replies View Related

Setting Up Client PC To Access Remote SQL Server

Jul 20, 2006

Hi,

I am a VB6 programmer and I'm really new to SQL Express, I have always used ACCESS because it was so easy to deploy. I've now written a VB6 program which uses SQL Express and I want to know how to deploy it. Basically my PC will host the SQL database as it has SQL Express loaded onto it. I now want to install my EXE onto other Client's PC and have them read/write to the database on my machine.

Besides the EXE program, what software do I need to load onto the Client's PC so they can access my SQLExpress database...? (eg: Net Framework, SQLExpress, etc).

Also, if my machine is called ABC123, in my connectionstring do I just put in

ABC123sqlexpress as the datasource..?. Will this be enough for the other PCs to connect to mine ?

Thanks

View 8 Replies View Related

Client Access Licenses Needed For Sql Express Or Not

May 4, 2007

we have a sql express - that comes standard with servers.I just wanted to know.....Is there any addition Client access licenses needed for this sql express or not.

View 1 Replies View Related

Cant Get Access Database Synchronizer Set Up On Client Machine

Apr 17, 2007



I have created a PPC application that uses ADS to synchronize my sqlce db with a desktop MS Access database. It works fine on my computers, but my client cant get it to work on his. Here is the situation.



His "Computer Name" as it's stated in his 'My Computer' properties is "PAVSGP024FE.NWFSC.NOAA.GOV"



However his Access.MDW File is located in the directory "C:Documents and SettingsJoe NobodyApplication DataMicrosoftAccessSystem.MDW".



There is no directory called "C:Documents and SettingsPAVSGP024FE.NWFSC.NOAA.GOVApplication DataMicrosoftAccessSystem.MDW".



His current config.xml file looks like this.



<?xml version="1.0" encoding="UTF-8"?>
<SystemNode>
<AccessDB>C:Program FilesNOAA Release LoggerNOAA_ReleaseLogger.mdb</AccessDB>
<DeviceDB>Program FilesNOAA Release LoggerNOAA_ReleaseLogger.sdf</DeviceDB>
<Login>Joe Nobody</Login>
<URL>http://Joe Nobody:1024/</URL>
<WinDir>C:</WinDir>
</SystemNode>



He has tried adding port 1024 as an exception for his firewall settings, has installed Access Database Synchronizer on his computer, and I have also tried using the "long" computer name as the url setting in the config file. (i.e. <URL>http://PAVSGP024FE.NWFSC.NOAA.GOV:1024/</URL> but this throws the error



"The HTTP request failed due to incorrect format or content. Try restarting the IIS server.[]"



I dont know what else to try! Anybody have any suggestions?

View 5 Replies View Related

Client Cannot Access SQL 2005 Express Server

Jun 21, 2007

I've installed SQL 2005 Express, enabled local and Remote connections but my client app cannot connect to the SQL server. I'm getting access denied or SQL does not exists. Any idea's on how to resolve this issue?

View 1 Replies View Related

Client On Domain Cannot Access SQL Server On Workgroup

Oct 12, 2007

Hi,

I have a quick question regarding domains and workgroups.

Currently I am working on an issue in the office of a small business. Right now there are 3 client computers that connect to a dell server running windows std. server 2003. The server has sql running on it that takes care of the invoicing system. Two out of the three work stations are able to use the database fine, but there is one that is unable to connect to the database. The only different that I could find is that the two workstations that DO work are currently set to use a workgroup, whereas the one workstation that does NOT work is set to use a domain...... I tried switching that computer to workgroup, but then I was unable to login as the normal user that I had always logged in as before.....

What can I do to solve this dilemma?

Any help would be greatly appreciated!

I apologize if this is the wrong forum for this, and if it is, if someone would point me to the correct one I would appreciate it.

Thanks
-steve

View 4 Replies View Related

My XP Client Doesn't Access SQL Server 2000

Aug 9, 2006

Hi,
I have a server (WIN 2000 server), is connected with many clients mostly having Win 2000 Professional OS. My application is developed in VB 6.0 and we have MS SQL Server 2000 DB in our server. All the clients with win 2000 professional have no problem with connecting and accessing my SQL Database. But few of my WIN XP clients don€™t connect to database thru my application. It gives error as follows.

Runtime error
Login Failed for user €˜(null)€™ . Reason: Not associated with a trusted SQL Connection.

Can anyone help me?

Regards
Ahmed Sahib

View 6 Replies View Related

How To Access To Excel,csv Or Other Formatted File Using OLE DB(SQL Native Client)?

Apr 13, 2007

Hi~.

First, is it possible to access(read/write) to the excel,csv or my-own-formatted file using OLE DB(SQL Native Client)?



If possible, how?

View 1 Replies View Related

How To Access Output (Inserted.ColName) From Client Application ?

Nov 6, 2006

I am using SQL Express 2005 and VB .net Express.

Question 1:

How can I get the result stored in Inserted.ColName (by Output clause of insert command). In the documentation (BOL) for SQL 2005, there is written "returned to the processing application for use" in Output clause (first paragraph).

Question 2:

How to store Inserted.ColName into local variable when insert command is running in stored procedure.:

View 8 Replies View Related







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