Cant Connect To SQL Server At Work From Home Project
Mar 6, 2005
HI All,
i have copied a project from work i am working on and have created the same project at home in visual studio.net - everything is the same as it is at my work - for some reason though i cannot connect to the servers from my home project
can anyone help me with this - i get the message "SQL Server does not exist or access denied"
my web config has exactly the same set up with a key in appSettings as
<add key="My_Connection" value="User ID=myID;Password=myPassword;Initial Catalog=myCatalog;Data Source=xx.xx.xx.xx" />
can anyone tell me why i would not be able to even see my work database from home?
thanks in advance
Gilesb
View 5 Replies
ADVERTISEMENT
Jan 17, 2008
Hello,
I've created a Report Model Project that can be used by Report Builder to generate ad-hoc reports. I'm trying to create a connection string in my Report Server Project that points to the Report Model Project data source view.
All I can do is create a regular datasource, which bypasses the metadata contained in the Data Source View.
Basically I want my Report Server Project and my Report Builder reports to leverage the same metadata. Is this possible? If so how do I get the connection string?
Thanks!!
-Matt
View 1 Replies
View Related
Dec 18, 2007
I'm green on this networking stuff so any help is greatly appreciated.
I have setup my home computer as a server and assigned a static IP to it. I installed SQL Server 2005 Developer and allowed remote connections to it through the Surface Area Config tool, added port 1433 TCP and 1434 UDP to firewall's exception list, and started the SQL Server Browser service.
Now I can't seem to remote connect to this SQL Server from my office network. Is there something I'm doing wrong here?
Thanks!!
View 3 Replies
View Related
Jul 24, 2000
Hello All,
I just got a new computer from work for Home use, and I need to figure out what would be the best way to transfer databases I create at home to work? I have a zip 250 disk, but what would be the best method?, What files need to be copied, what does it all entail?
Thanks for the help
Kevin
View 1 Replies
View Related
Aug 6, 2005
Hi! I installed SQL Server on my server today and im new to it. I configured it and now im trying to make a SQL Server Project with my other computer... Then the program asks for some account information to logon to a database on the server. Then i fill it out and i get this error: Login failed for user "anaxyd". The user is not associated with a trusted SQL Server connection.
View 7 Replies
View Related
Mar 27, 2008
When using my Work laptop while at home, how can I log into an SQLServer Express 2005 database on a home server, using Windows Authentication, without having to VPN in and log onto the network at Work? If I VPN into work then I can connect to my home db just fine.
I have a laptop which I carry from work to home each day. I'm a Domain Admin at work so my network login name is DOMAINjoe. At home I have 5 PCs in a home network, WorkGroup is WORKGROUP. When I carry my laptop home I log in exactly as I do at work. All is fine. File sharing, printer sharing, & internet all work between my 5 PCs.
I installed SQLServer Express 2005 on a home PC I use as a server (Vista Business edition). Home server's name is STAR. I developed a database called AddressBk on my laptop (Visual Studio 2008) using my laptop's local copy of SQLServerExpress. App works fine. I copied the Db files onto my home server STAR. My user name on STAR is Joe2, so while logged onto Star as Joe2 I used Star's SQLServer Management Studio Express to connect the AddressBk db to Star's copy of SQLServer Express. All is fine.
Now if I use my LapTop on my home network and try to connect to AddressBk on STAR I get a connection error. I get the error whether connecting using SQLServer Management Studio Express or using Visual Studio 2008. The SQLServer Management Studio Express connection screen shows I'm connecting using Windows Authentication and my User Name is DOMAINjoe. I presume this is the problem as I can not add a user on Star with a Domain Name. Other PCs on my home network can connect to AddressBk db on Star without a problem. If my labtop VPNs into work then I can connect just fine.
Here is the connection string my App uses.
Data Source=STARSQLEXPRESS;Initial Catalog=AddressBk;Integrated Security=True;connection timeout=60
How can I connect to my db without having to VPN into work?
Thanks for any help.
Joe A
View 2 Replies
View Related
Nov 24, 2015
I installed Reporting Services 2014 on Windows 7. When i am trying to start home page i can see only HTML page and the text: "localhost/reports - /",then double lines (<hr><hr>) and text "Microsoft SQL Server Reporting Services Version 12.0.4100.1"Maybe the windows user (SERVER_NAMEADMINISTRATOR) has not sufficient permissions ?
View 3 Replies
View Related
Jun 27, 2006
Hi all,
I have to deal with a private network of laptops which are all equiped with preinstalled "Windows XP home"
I've installed SQLExpress on one of these, but I cannot connect on it from the rest of the laptops. (I've successfuly done this with "Windows XP profesional" though, and local connections work fine as well).
I've already setup the SQLExpress to accept conections throuigh TCP/IP but I can not think of something else. (Security comes to mind, but I do not know how to resolve it on "Windows XP Home").
Thank you
Ioannis
View 6 Replies
View Related
Jan 5, 2007
Hi,
I have Windows XP Home Workgroup LAN.
I am treating one of the XP Home system as 'Server' and installed SQL Express 2005 SP1. Enabled remote connections access.
I have total 4 XP Home systems, out of which one i am treating as Server, from the rest 3 computers, 2 are successfully connected to the Server and able to access SQL Express without any problems. But the 3rd system is unable to communicate with the Server. I disabled all firewalls in this 3rd system but still unable to connect to the server. I am able to ping the server, browse for shared folders on the server. Except SQL Express remote connection, everything else in the network is accessible from this 3rd computer.
Can anyone help me on how to troubleshoot this 3rd computer sql express connection problem to the server.
I don't have any error message to provide here. It just says, unable to connect to sql server, verify username/password etc.
Is there any limitation on SQL Express remote connections ?
View 1 Replies
View Related
Jun 10, 2015
I see we can install SQL Server 2016 CTP2 and Tabular SSAS.However, where are the tools to allow us to connect to the server and work with the tabular models?Supporting features such as bi directional filtering, etc..The existing SSDT BI tools for 2014 don't contain those additional features (editing relationship filtering direction for example).
View 2 Replies
View Related
Oct 22, 2015
I have a VS 2012 SSIS project with more and more packages being added. I've got project parameters so I'm committed to the project deployment model (which is pretty convenient BTW). My question is how we're supposed to occasionally limit the packages we want deployed. There are times when 2 or more packages may be in development and 1 is deployable and the other not. I can temporarily exclude the not ready package and then deploy. It seems cumbersome bringing it back in. BIDS complains that all the tasks have lost their connection managers; even though they're are present in the editor. And it makes a copy of the .dtsx.
what's the recommended way to work in this environment?
View 2 Replies
View Related
Jun 3, 2007
i have created a database endpoint that just retuns some data. i am trying to call this endpoint as a web service in visual studio by adding a web reference, but i cannot find my endpoint. it seems to just check iis for endpoints, but how do i make it look for my sql endpoint? here is the code for my endpoint.
create endpoint testEndpoint authorization [FINTAN-PCFintan]
state=STARTED
as http
(
path ='/sql',
authentication=(INTEGRATED),
ports = (CLEAR),
site='SERVER'
)
For SOAP
(
webmethod'ProvideSQLData'(name='adventureWorks.dbo.testEndpointProcedure'),
WSDL=DEFAULT,
SCHEMA=STANDARD,
DATABASE='adventureworks',
NAMESPACE='http://thenamespace.org'
);
GO
the account that visual studio is running under has been granted connect permissions on the endpoint. can anyone say where im going wrong here?
View 2 Replies
View Related
May 6, 2007
Hi,
I want to update value of a custom field for a perticular project in Project Server 2007 using PSI.
I have created 5 enterprise custom fields(A,B,C,D,E) through PWA/Server Settings.
I want to search all Projects on Server. If any project is having value for custom field A then I want to update rest of the custom fields(B,C,D,E) for that perticular project.
I dont know how to do it please help.
Thanks in Advance
Madhukar
View 5 Replies
View Related
Jul 23, 2007
I fail to use project professional 2003 to access to the project server 2003 using MSDE 2000 in local area network, following message was shown,
Connection failed:
SQLState: '01000' SQL Server Error 1326 [Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen (Connect())
Connection failed:
SQLState '08001'
SQL Server Error: 17
[Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied.
I have seen these pages with similiar cases but can't help.
http://support.microsoft.com/kb/818047/
http://support.microsoft.com/kb/837653/en-us
Can anyone help me?? Thanks a lot!
View 1 Replies
View Related
Jun 2, 2005
I'm new to asp.net and databases and I'm currently working my way through SAMs Teach Yourself ASP.I am up to working with databases and have successfully installed MSDE using the sql2kdesksp3.exe file. However, when I try to create a new database through the web matrix project I get an 'unable to connect' error. I have tried removing and re-installing the database and I've also re-installed it using the latest file from the MS web site but I still get the same error. I've checked the obvious...that the msde service is running, password is correct, and that checks out ok.Has anyone had a similar problem and resolved it?Thanks.
View 2 Replies
View Related
Sep 29, 2015
I have a ssas tabular model as a data source in a .pbix-file. I have uploaded the .pbix-file to Power BI Services and it works fine as long as my visual studio project is open. If I close my visual studio project, the objects in Power BI Services will say "The data recievement for this visual information was not successful."
View 2 Replies
View Related
May 8, 2008
Hi,
I'm trying to create a case function for home phone ,work phone and cell phone. The thing is some of the home phone numbers either null, zero or less than 10 digits then i'd like to get either cell phone or work phone if they are not null, zero or less than 10 digits.
I'd appreciate it if you could help me on this?
Thanks in advance.
View 19 Replies
View Related
May 29, 2008
For some reason in a Team Foundation Team Project that has multiple project types (SSRS, SSIS, WebSite, C# Business DLL...), the SSIS project makes itself the startup project to the team project. If I explicitly set another project as the startup project to the team project and then select an SSIS package in the SSIS project in the team project, the SSIS project becomes the startup project automatically.
I am using Visual Studio 2005 SP1.
View 3 Replies
View Related
Mar 13, 2008
Hi all How can create trigger in sql server project in VB.NET 2.0 ?thanks in advance
View 1 Replies
View Related
Nov 22, 2006
Hello -
I've setup SQL Server 2005 from scratch over half a dozen times now. I have remote connection down cold.
Install the SQL Server. Run Surface config. Enable remote connection over TCP/IP and named pipes. Set up client alias. Restart SQL Server. (I install for mixed mode every time.)
Every time this has worked up till now. Start up SQL Server Mgmt Studio, select the server to login to, enter the sa user name and password, boom, you're in.
This time I cannot get in. Connection is denied both for sa and windows authenticated login as Administrator. This is the two line dump from event viewer - the first is an audit problem, the second is the error.
Event Type: Failure Audit
Event Source: MSSQLSERVER
Event Category: (4)
Event ID: 18452
Date: 11/22/2006
Time: 7:47:12 AM
User: N/A
Computer: WFR01
Description:
Login failed for user ''. The user is not associated with a trusted SQL Server connection. [CLIENT: 10.1.2.236]
For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
Data:
0000: 14 48 00 00 0e 00 00 00 .H......
0008: 06 00 00 00 57 00 46 00 ....W.F.
0010: 52 00 30 00 31 00 00 00 R.0.1...
0018: 07 00 00 00 6d 00 61 00 ....m.a.
0020: 73 00 74 00 65 00 72 00 s.t.e.r.
0028: 00 00 ..
Event Type: Error
Event Source: MSSQLSERVER
Event Category: (4)
Event ID: 17806
Date: 11/22/2006
Time: 7:47:12 AM
User: N/A
Computer: WFR01
Description:
SSPI handshake failed with error code 0x8009030c while establishing a connection with integrated security; the connection has been closed. [CLIENT: 10.1.2.236]
For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
Data:
0000: 8e 45 00 00 14 00 00 00 ŽE......
0008: 06 00 00 00 57 00 46 00 ....W.F.
0010: 52 00 30 00 31 00 00 00 R.0.1...
0018: 00 00 00 00 ....
The only thing different is that this server is a terminal services server. I put the server into install mode before I installed SQL Server. After installation and surface config but before restart, I put the server back into execute mode.
Is there a problem installing SQL Server on a Terminal Services Server? If not, I cannot figure out what the problem is.
Thanks in advance for the help
View 6 Replies
View Related
Nov 4, 2006
Hi,
I am new to SSIS. I followed the direction of the tutorial Creating Simple ETL Tutorial package in BooksOnline. I have tried more than five times and have done exactly as suggested in the tutorial but it does not work.
The URL is:
http://msdn2.microsoft.com/en-us/library/ms169917.aspx
I get these warnings and finally fails:
1)[Lookup [30]] Error: Row yielded no match during lookup.
2) [Lookup [30]] Error: The "component "Lookup" (30)" failed because error code 0xC020901E occurred, and the error row disposition on "output "Lookup Output" (32)" specifies failure on error. An error occurred on the specified object of the specified component.
3) [DTS.Pipeline] Error: The ProcessInput method on component "Lookup" (30) failed with error code 0xC0209029. The identified component returned an error from the ProcessInput method. The error is specific to the component, but the error is fatal and will cause the Data Flow task to stop running.
4) [DTS.Pipeline] Error: Thread "WorkThread0" has exited with error code 0xC0209029.
Can someone help me with this tutorial error? or Am I doing something wrong.
Thank you,
View 6 Replies
View Related
Jan 6, 2005
It seams as if the Connect Timeout property is not working correctly if the server that one is trying to connect to is down. This is my connection string.
Provider=SQLOLEDB;Pooling=False;Data Source=172.16.136.4;Initial Catalog=Db1;User ID=test;Password=test;Connect Timeout=5;
The timeout is ignored and the connection times out after about 15/20 seconds?
Any ideas?
View 2 Replies
View Related
Jun 7, 2007
I have a stored proc to query a very large database, and it always times out at the 30th sec, even though I have changed the connect timeout to 300, as follows
(Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.)
Data Source=.SQLEXPRESS;AttachDbFilename="C:Documents and SettingsAdministratorMy Documentsabc.mdf";Integrated Security=True;Connect Timeout=300;User Instance=True
This timeout issue does not occur to smaller databases. Any idea?
View 5 Replies
View Related
Jan 19, 2006
Hi,
Please direct me to the right forum if this is not the right one.
Upon installation of SQL Server 2005, I opened the SQL Server Management Studio, connected using Windows Authentication and went to the security node in the tree. I created a log in called "TestLogin". I restarted my server just to make sure everything took and when I tried to log in using TestLogin via SQL Server Authentication, I get the below error. I have mixed mode enabled as well as named pipes. I am not sure what the issue is or what to try next. I even get the same error when trying to use "sa".
Thanks,
- Joel
TITLE: Connect to Server
------------------------------
Cannot connect to TestServer.
------------------------------
ADDITIONAL INFORMATION:
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
------------------------------
BUTTONS:
OK
------------------------------
View 3 Replies
View Related
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
Jul 1, 2006
Hi All,I've been struggling with this for hours...Could someone please advise me on how to convert my current File based SQL Server Express website to a Server based SQL Express one.Particularly interested in what I need to do in the SQL Express management tool, changes I need to make the projecvt itself and changes needed to get IIS to understand things have been changed.Thanks,Martin.
View 1 Replies
View Related
Aug 18, 2015
Basically, I am asking if it is possible to use SSMS (Query Analyzer window) with Informix. I am thinking linked server. If I have the ODBC driver installed on my workstation (win 7 pro VM workstation -- SSMS on same VM machine) is this doable? Do I just do the standard linked server routine or is there a special way (if it is even doable).
View 4 Replies
View Related
Dec 1, 2005
Here is the problem, i'm sure there is quite a bit on google but i'm
not sure what to search for. I want to know how to connect to a
sql server from my home machine using the localhost for testing asp.net
files out. At work the machines will connect fine using
localhost. The server we connect to is in another location.
If someone could get me started on what to search for i would
appreciate it.
View 3 Replies
View Related
Oct 5, 2005
Hi All,
I'm trying to run a copy of Enterprise Manager at home. I have a small wireless network and would like to install it on either one machine (stand-alone) or run it on my network.
The machine it is installed on is running Windows 2000 and the remote machine is running Windows XP Home <<< not sure if SQL Server will run on this.
I tried installing it previously as stand-alone on the Win2K machine, but kept getting a "Server not found or access denied" message whenever I tried to register or connect.
Any ideas on how best to set it up at home would be greatly appreciated.
Thanks,
Tim
View 2 Replies
View Related
Mar 10, 2007
Hi all:
How to install a sql server 2005 in a computer with windows Xp Home Edition?
Thanks
View 3 Replies
View Related
Feb 9, 2007
How can I practice the use of SQL server without changing mygirlfriends laptop to XP Pro (which anyway I dont have)?Using (unfortunately) Windows XP Home not Pro, Visual Studio 2005.Trying to learn SQL server with asp, javascript, vbsrcipt and HTML-new to this.Headbutted the wall for a few hours trying to install SQL Serverproperly. The long and short is no IIS with Win XP Home so doesnt seemto work properly. I did manage to connect to Northwinds and publs DBso can use them to learn but I need to be able to ceate own database.Ie 3 tables.For the moment I have created a table in Northwind which I will try tofill with datafrom a notepad file I have...Dan
View 2 Replies
View Related
May 3, 2006
Hi
I am new to SQL / SQL Server and have downloaded SQL Server 2005 Express.
I also appear to have an existing SQL Server program on my PC which includes Query Analyzer. I wish to use Query Analyzer. Is this compatible with SQL Express?
When I try to open Query Analyzer using Windows Authentication I get the error msg:
'Unable to connect to server HOME-DHGV3DIC8N:
Server: msg 17, level 16, state 1
[Microsoft] [ODBC SQL Server Driver] [Shared memory] SQL Server does not exist or access denied.'
I am guessing that I need to create some sort of server which I can use to run SQL server.
Could anyone let me know how I do this? And also if I will be able to run Query analyzer on SQL Express edition.
I'd be really greatful
Regards
Mark
View 11 Replies
View Related
Feb 17, 2008
I am new to servers and when I try to learn about them I get confused, because the information does not list a server in XP, but they keep it separate from Microsoft SQL Server, like XP has it's own server. Can someone help clarify for me what the versions of SQL servers are?
SQL 2000 1.0, SQL 2002, SQL 2003........?
View 10 Replies
View Related
