By the way, thanks again for all the help guys...You've pointed me in the right direction several times and this is a fine example of persitance paying off.
cheers,
splat78423
I finally got it....When SQL is setup it doesnt enable these types of remote connections by default. I had to enable tcp/ip connections directly to the database and also enable named pipes.....I then stopped and restarted the SQL service..I then went to setup my ODBC connection and it took by...
I double checked the client configuration when I tried setting it up the last time and it was was set properly to tcp/ip.....I can ping the server itself
ie:
ping servername
but I cant ping or telnet to the database
ping servername\database
or
telent servername\database 1433
I have...
I'll give it a shot but since I setup the entire network I know for sure that my firwall is not blocking the connection. I have checked and double checked my server name and, username, and password but the ODBC connection wont setup. My database server and my client machine are on the same local...
splat78423 (IS/IT--Management) 24 Aug 06 10:38
I have never used crystal befor and I am simply trying to set it up on my workstation and start a new report with access to my SQL 2005 database....I have full administrative access across all systems so that wont be a problem...... I just need a...
I am verifying it by logging into my file server with admin access rights then into SQL Server Management studio express with and checking the instance name, etc. I have administrative access to the server so I am just using those credentials. All the info I need is right there as far as...
while creaing the ODBC data source connection I get the following error...
Connection failed
SQL State: '01000'
SQL Server Error: 2
[Microsoft][ODBC SQL ServerDriver][DBNetLib] ConnectionOpen(connect())
Connection failed:
SQL State '08001'
SQL Server Error: 17
Server does not exist or access denied
while creaing the ODBC data source connection I get the following error...
Connection failed
SQL State: '01000'
SQL Server Error: 2
[Microsoft][ODBC SQL ServerDriver][DBNetLib] ConnectionOpen(connect())
Connection failed:
SQL State '08001'
SQL Server Error: 17
Server does not exist or access denied
I'll try it out again tomorrow when I'm back in the office and let you exactly what the message is. It basically said that either the username or passwor dis bad or the server does not exist.....I'll see if I can get you a message number or error code in the morning.
I certainly do appreciate...
I tried installing crysal reports on the computer that hosts the SQL server software but I just get a hundred Error 1904 Module blah blah blah failed to launch messages....Individually registering each individual .dll is not possible because there are way to many to register manaully.....No one...
I'm trying to setup a ODBC data soure for my computer so I can hook up crystal reports to my SQL server (which I have administrative access to). However I cant connect in data source administrator even after I have verified servername, database name, and login info several times...The error...
I found an article that say not to try to connect natively to a SQL database with crystal because a .dll file in crystal reports hasnt been updated... Is this what I am trying to do here? I am trying to connect the same way I've described in my first post.....I just dont get it...
I am having problems just connecting to my database now and its on the server I am sitting right next to! I am entering the correct servername and database, as well I am entering the network admin username and password but it is not taking! I am sure the net connection is fine and this is a...
Ill try all of that out and let you know how it goes. I am new at this DBA stuff (sql, crystal, etc....) but my SQL server imports text files into the database every night which contain updates to my tables. All of the info in the tables are stored in 5 text files for the import so I was also...
I have never used crystal befor and I am simply trying to set it up on my workstation and start a new report with access to my SQL 2005 database....I have full administrative access across all systems so that wont be a problem...... I just need a push in the right direction. Do I create a new...
The screen saver goes on but then I am not prompted for a password when I move the mouse (even though I've checked the box for password protection). This would not be a big deal if it were happening on a desktop or home PC but this is happening to my 2003 file server..
Oh ok,I see now, that does make alot of sense. I'll pick a cheap linksys router up and then take it from there.....Now that I think of it I may have one back in storage somewhere......
I see that multple modes are available but how do I configure between one and another in the CLI, that is my question? I am pretty sure that a cable mode exists, I just dont know how to switch the router into that mode. In other words, I am looking for someone out here who knows the exact CLI...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.