Showing posts with label access. Show all posts
Showing posts with label access. Show all posts

Sunday, March 25, 2012

Can't Attach sqlexpress db

Hi,

After having published the timetracker starterkit from visual studio 2005 to local wwwroot,

I try to access my homepage with ie.

But still get the same error message :

An attempt to attach an auto-named database for file C:\Documents and Settings\Emmanuel\My Documents\Visual Studio 2005\WebSites\GestWares\App_Data\TimeTracker.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share.

This is how i configure my web.config :

<connectionStrings>

<remove name="LocalSqlServer"/>

<add name="LocalSqlServer" connectionString="Data Source=.\SQLExpress;Integrated Security=True;AttachDBFilename=|DataDirectory|\TimeTracker.mdf;User Instance=true"/>

<add name="aspnet_staterKits_TimeTracker" connectionString="Data Source=.\SQLExpress;Integrated Security=True;AttachDBFilename=|DataDirectory|\TimeTracker.mdf;User Instance=true"/>

<add name="ConnectionString" connectionString="Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\TimeTracker.mdf;Integrated Security=True;User Instance=True" providerName="System.Data.SqlClient"/>

</connectionStrings>

Has someone any idea how my connectionstrings statement has to look like?

thanks in advance.

Manu.

Hi,

Refer below links for work around.

http://www.aspspider.com/resources/Resource170.aspx

http://www.sqljunkies.com/WebLog/ktegels/archive/2005/11/15/17401.aspx

http://www.ozzu.com/ftopic43909.html

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=989092&SiteID=1

Hemantgiri S. Goswami

Thursday, March 22, 2012

can't add current login as user

Hi all. I'm having problems trying to add a current login
as a user to any databases. The logins are there, but
when I try to give one access to another db, or even if I
try to add user from within the db itself, I get error
15401 (Windows NT user or group not found). I looked in
KB but could only find this error in reference to adding a
new login. As stated, the logins are already setup and
have been for about two years now, the system just won't
let me add them as users.
What really gets me is how SQL Server will let me use the
necessary tool to pick the login from the list, but then
it says it's not found. (?)
Thanks in advance for any help!
Sandy MachCheck the following KB article:
HOW TO: Troubleshoot Error 15401
http://support.microsoft.com/?id=324321
-Sue
On Thu, 25 Mar 2004 08:47:51 -0800, "Sandy Mach"
<anonymous@.discussions.microsoft.com> wrote:

>Hi all. I'm having problems trying to add a current login
>as a user to any databases. The logins are there, but
>when I try to give one access to another db, or even if I
>try to add user from within the db itself, I get error
>15401 (Windows NT user or group not found). I looked in
>KB but could only find this error in reference to adding a
>new login. As stated, the logins are already setup and
>have been for about two years now, the system just won't
>let me add them as users.
>What really gets me is how SQL Server will let me use the
>necessary tool to pick the login from the list, but then
>it says it's not found. (?)
>Thanks in advance for any help!
>Sandy Mach|||As previously stated, I read that article before posting
here, and it refers only to adding new logins... these
LOGINs are already existing within SQL Server Security
Logins. SQL Server will not let me grant any of the
current logins access to any additional databases (will
NOT let me add current LOGIN as NEW USER), and the only
error I get is that 15401 which doesn't make sense in this
situation.
SQL Server lets me use the drop-down box showing current
logins to choose as new user, so it's finding them fine
there. It lets me go thru all the motions until it comes
time to save, then it says it can't find the user or group
(when IT let me find them thru its own nav tools!!).
Any other suggestions?

>--Original Message--
>Check the following KB article:
>HOW TO: Troubleshoot Error 15401
>http://support.microsoft.com/?id=324321
>-Sue
>On Thu, 25 Mar 2004 08:47:51 -0800, "Sandy Mach"
><anonymous@.discussions.microsoft.com> wrote:
>
login
I
a
the
>.
>|||Hi, I'd the same error when I tried to add an user group (domain user group)
to new login (sql server).
What I did was instead of clicking on be "..." button (browse no Name), I ty
ped in manually "BUILTIN\Users" (assuming I want to add "Users" user group)
and click "OK". and guess what? It works for me.
Posted using Wimdows.net NntpNews Component -
Post Made from http://www.SqlJunkies.com/newsgroups Our newsgroup engine sup
ports Post Alerts, Ratings, and Searching.

Can't add anything new? HELP!

Ok, we have two SQL servers running for the past year or
two. I dont make changes often but today we opened up our
access program to connect to the SQL server. Whenever I
add a new table it's blank. It allows me to add the
category but when I click on the table to add info, the
column names are there but no while boxes. It's almost
like it's read only, excelt I'm using the sa account when
logging in. So, For kicks I set up another server (from
scratch (all are 2003) and am getting the same thing with
that also. I don't understand it.
With enterprise manager I can add info to the database,
but not from any computer trying to access it from
Microsoft Access. If I copy an exisiting table, I can add
items to that, just not creating a new one. Has anyone
else seen this problem?
I've been at this now for about 8 hours and I'm going
nuts. I've even created a new account called "test" gave
it ever permission available (admin, and all) and when I
try to open a table I create a I get a message that the
database has been disconnected. But whatever it is, all
the servers are doing the same thing. Could it be a patch
for WIN 2003 that might have caused it? I'm reaching here
but nothing seems to work. So here I am with 3 servers
now and I can't add a table to any of them unless it's
from enterprise manager. And even though I can add the
table (and data) from there, it's still read only like
when I open it in Access. There's no final row to add
more information into...
Help?Is this a shared Access database on a network drive?
--
Andrew C. Madsen
Information Architect
Harley-Davidson Motor Company
"Steven C" <anonymous@.discussions.microsoft.com> wrote in message
news:1f75f01c457c4$c7572480$a401280a@.phx.gbl...
> Ok, we have two SQL servers running for the past year or
> two. I dont make changes often but today we opened up our
> access program to connect to the SQL server. Whenever I
> add a new table it's blank. It allows me to add the
> category but when I click on the table to add info, the
> column names are there but no while boxes. It's almost
> like it's read only, excelt I'm using the sa account when
> logging in. So, For kicks I set up another server (from
> scratch (all are 2003) and am getting the same thing with
> that also. I don't understand it.
> With enterprise manager I can add info to the database,
> but not from any computer trying to access it from
> Microsoft Access. If I copy an exisiting table, I can add
> items to that, just not creating a new one. Has anyone
> else seen this problem?
> I've been at this now for about 8 hours and I'm going
> nuts. I've even created a new account called "test" gave
> it ever permission available (admin, and all) and when I
> try to open a table I create a I get a message that the
> database has been disconnected. But whatever it is, all
> the servers are doing the same thing. Could it be a patch
> for WIN 2003 that might have caused it? I'm reaching here
> but nothing seems to work. So here I am with 3 servers
> now and I can't add a table to any of them unless it's
> from enterprise manager. And even though I can add the
> table (and data) from there, it's still read only like
> when I open it in Access. There's no final row to add
> more information into...
> Help?|||Are you saying you cannot add data to an SQL Server table from MS Access?
If so, you'll need to define at least one column with a unique index.
Steve
"Steven C" <anonymous@.discussions.microsoft.com> wrote in message
news:1f75f01c457c4$c7572480$a401280a@.phx.gbl...
> Ok, we have two SQL servers running for the past year or
> two. I dont make changes often but today we opened up our
> access program to connect to the SQL server. Whenever I
> add a new table it's blank. It allows me to add the
> category but when I click on the table to add info, the
> column names are there but no while boxes. It's almost
> like it's read only, excelt I'm using the sa account when
> logging in. So, For kicks I set up another server (from
> scratch (all are 2003) and am getting the same thing with
> that also. I don't understand it.
> With enterprise manager I can add info to the database,
> but not from any computer trying to access it from
> Microsoft Access. If I copy an exisiting table, I can add
> items to that, just not creating a new one. Has anyone
> else seen this problem?
> I've been at this now for about 8 hours and I'm going
> nuts. I've even created a new account called "test" gave
> it ever permission available (admin, and all) and when I
> try to open a table I create a I get a message that the
> database has been disconnected. But whatever it is, all
> the servers are doing the same thing. Could it be a patch
> for WIN 2003 that might have caused it? I'm reaching here
> but nothing seems to work. So here I am with 3 servers
> now and I can't add a table to any of them unless it's
> from enterprise manager. And even though I can add the
> table (and data) from there, it's still read only like
> when I open it in Access. There's no final row to add
> more information into...
> Help?|||Yea exactly... I have an .adp file that opens the
database on the SQL server using sa as the ID. When I
create a new table using "design view" I:
1. Enter a few columns, for example right now I just put
one with Name, Address. Name is set to nvarchar with 50
as the length and Address is the same
(even made name an indexed field for kicks)
2. Clicked on the X box at the top right to close of that
window
3. Access says "DO you want to save changes to the design
of table2?
4. Selected Yes and then prompted with what name I want
to call it, put in test for this example
5. Get the standard message that no primary key is
defined. Told it Yes to create one.
6. Now, normally that design view goes away but it's
still here so clicked on the X again to close it out.
I now see "test" as a table. Click on test and I get the
standard view to enter data. However, I see Name and
Address as column headers but no box under it to enter
information. And at the bottom of that screen the only
box that is not grayed out is the one to set the max
record count being displayed.
Yes, nothing seems to work. On all three of the SQL
servers I get the same exact thing. Thought maybe by
chance it was my computer, went to another one and
created a bring new adp file on that system... same
thing...
I don't understand it... You can enter items into
anything that is already created, but nothing you create
new. And, the three server are *not* connected except for
all being in the same domain. No data is replicated
between them so it's something recent that caused it and
I honestly don't know where to begin...
I'm stumped.
>--Original Message--
>Are you saying you cannot add data to an SQL Server
table from MS Access?
>If so, you'll need to define at least one column with a
unique index.
>Steve
>"Steven C" <anonymous@.discussions.microsoft.com> wrote
in message
>news:1f75f01c457c4$c7572480$a401280a@.phx.gbl...
>> Ok, we have two SQL servers running for the past year
or
>> two. I dont make changes often but today we opened up
our
>> access program to connect to the SQL server. Whenever I
>> add a new table it's blank. It allows me to add the
>> category but when I click on the table to add info, the
>> column names are there but no while boxes. It's almost
>> like it's read only, excelt I'm using the sa account
when
>> logging in. So, For kicks I set up another server (from
>> scratch (all are 2003) and am getting the same thing
with
>> that also. I don't understand it.
>> With enterprise manager I can add info to the database,
>> but not from any computer trying to access it from
>> Microsoft Access. If I copy an exisiting table, I can
add
>> items to that, just not creating a new one. Has anyone
>> else seen this problem?
>> I've been at this now for about 8 hours and I'm going
>> nuts. I've even created a new account called "test"
gave
>> it ever permission available (admin, and all) and when
I
>> try to open a table I create a I get a message that the
>> database has been disconnected. But whatever it is, all
>> the servers are doing the same thing. Could it be a
patch
>> for WIN 2003 that might have caused it? I'm reaching
here
>> but nothing seems to work. So here I am with 3 servers
>> now and I can't add a table to any of them unless it's
>> from enterprise manager. And even though I can add the
>> table (and data) from there, it's still read only like
>> when I open it in Access. There's no final row to add
>> more information into...
>> Help?
>
>.
>|||Did you declare a primary key for the table?
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Steven C" <anonymous@.discussions.microsoft.com> wrote in message
news:1f6a301c457d2$47504c90$a101280a@.phx.gbl...
> Yea exactly... I have an .adp file that opens the
> database on the SQL server using sa as the ID. When I
> create a new table using "design view" I:
> 1. Enter a few columns, for example right now I just put
> one with Name, Address. Name is set to nvarchar with 50
> as the length and Address is the same
> (even made name an indexed field for kicks)
> 2. Clicked on the X box at the top right to close of that
> window
> 3. Access says "DO you want to save changes to the design
> of table2?
> 4. Selected Yes and then prompted with what name I want
> to call it, put in test for this example
> 5. Get the standard message that no primary key is
> defined. Told it Yes to create one.
> 6. Now, normally that design view goes away but it's
> still here so clicked on the X again to close it out.
> I now see "test" as a table. Click on test and I get the
> standard view to enter data. However, I see Name and
> Address as column headers but no box under it to enter
> information. And at the bottom of that screen the only
> box that is not grayed out is the one to set the max
> record count being displayed.
> Yes, nothing seems to work. On all three of the SQL
> servers I get the same exact thing. Thought maybe by
> chance it was my computer, went to another one and
> created a bring new adp file on that system... same
> thing...
> I don't understand it... You can enter items into
> anything that is already created, but nothing you create
> new. And, the three server are *not* connected except for
> all being in the same domain. No data is replicated
> between them so it's something recent that caused it and
> I honestly don't know where to begin...
> I'm stumped.
>
> >--Original Message--
> >Are you saying you cannot add data to an SQL Server
> table from MS Access?
> >
> >If so, you'll need to define at least one column with a
> unique index.
> >
> >Steve
> >
> >"Steven C" <anonymous@.discussions.microsoft.com> wrote
> in message
> >news:1f75f01c457c4$c7572480$a401280a@.phx.gbl...
> >> Ok, we have two SQL servers running for the past year
> or
> >> two. I dont make changes often but today we opened up
> our
> >> access program to connect to the SQL server. Whenever I
> >> add a new table it's blank. It allows me to add the
> >> category but when I click on the table to add info, the
> >> column names are there but no while boxes. It's almost
> >> like it's read only, excelt I'm using the sa account
> when
> >> logging in. So, For kicks I set up another server (from
> >> scratch (all are 2003) and am getting the same thing
> with
> >> that also. I don't understand it.
> >>
> >> With enterprise manager I can add info to the database,
> >> but not from any computer trying to access it from
> >> Microsoft Access. If I copy an exisiting table, I can
> add
> >> items to that, just not creating a new one. Has anyone
> >> else seen this problem?
> >>
> >> I've been at this now for about 8 hours and I'm going
> >> nuts. I've even created a new account called "test"
> gave
> >> it ever permission available (admin, and all) and when
> I
> >> try to open a table I create a I get a message that the
> >> database has been disconnected. But whatever it is, all
> >> the servers are doing the same thing. Could it be a
> patch
> >> for WIN 2003 that might have caused it? I'm reaching
> here
> >> but nothing seems to work. So here I am with 3 servers
> >> now and I can't add a table to any of them unless it's
> >> from enterprise manager. And even though I can add the
> >> table (and data) from there, it's still read only like
> >> when I open it in Access. There's no final row to add
> >> more information into...
> >>
> >> Help?
> >
> >
> >.
> >sql

Can't Add a linked table to SQL Server 2005 with Access 2003

Hi,

I have an Access 2003 front end that contains a number of linked tables on SQL Server 2005 SE. I recreated the application on a second network for testing and was able to use the Linked Table Manager to refresh the database connections. The problem is when I try and add another linked table. I select Link Tables from the menu and then when I select 'ODBC Databases()' from the 'Files of Type' list box, the Link window closes right away.

Any suggestions?

I would post to MS Access newsgroups to get help on this, sounds like a problem with Microsoft Access ->

http://www.microsoft.com/office/community/en-us/default.mspx

My only feeble guess for you is that somehow ODBC is not installed correctly on the computer, try re-installing latest MDAC.

|||if you are running Norton AV , turn off the Office Plug in, Anti-virus/Options/Misc|||You can't modify tables in access 2003 against SQL 2005. I use access 2007 beta with good results.|||

I was having the same problem as bonkers1963 and I found this posting. I have Norton AV and the Office Plugin option was set on. I turned off the Office Plugin option and restared Access then I could link tables with no problem.

Thanks for the info.

Can't Add a linked table to SQL Server 2005 with Access 2003

Hi,

I have an Access 2003 front end that contains a number of linked tables on SQL Server 2005 SE. I recreated the application on a second network for testing and was able to use the Linked Table Manager to refresh the database connections. The problem is when I try and add another linked table. I select Link Tables from the menu and then when I select 'ODBC Databases()' from the 'Files of Type' list box, the Link window closes right away.

Any suggestions?

I would post to MS Access newsgroups to get help on this, sounds like a problem with Microsoft Access ->

http://www.microsoft.com/office/community/en-us/default.mspx

My only feeble guess for you is that somehow ODBC is not installed correctly on the computer, try re-installing latest MDAC.

|||if you are running Norton AV , turn off the Office Plug in, Anti-virus/Options/Misc|||You can't modify tables in access 2003 against SQL 2005. I use access 2007 beta with good results.|||

I was having the same problem as bonkers1963 and I found this posting. I have Norton AV and the Office Plugin option was set on. I turned off the Office Plugin option and restared Access then I could link tables with no problem.

Thanks for the info.

sql

cant access to remote MS SQL server!

Here is the connection string i used:

"Data Source=<IP>,1433;Network Library=DBMSSOCN;Initial Catalog=<dbname>;User ID=sa;Password=<pwd>;"

i use that to connect to the remote SQL server, which has status of port 1433 at "Stealth"... do i need to open the port complete, if yes how i do that ?

does the SQL Server must use SQL authentication ?

Your help is greatly appreciated.Try this:

server=<ip>;uid=sa;pwd=<pwd>;database=<dbname
Remove everything else from the connection string.|||thnx, btw, do i need to add the port # after the IP ?|||yes, if it is not default (not 1433)
if it is 1433, there is no need to specify it

cant access the datasource control

When I put a sqldatasource in my page and want to configure it and add a new connection to it I recieve this error : "object reference not set to an instance of an object" . Do you have any idea about solving this problem. please help me Thanks

Hi,

when asking a question about code or when you get an error always try to provide therelevant pieces of code and the error message that you get. This helps the people around here to better help you out.

Grz, Kris.

|||

My program has only a simple datagrid that should get data from a sql table and show it.This is only a test after changing the IIS settings. You can see my code here:

When I run this program I don't recieve any error but the explorer shows the blank page. When I try making connectionstring via sqldatasource I recieve that error:"the object reference...".thanks for helping

public

partialclassado1 : System.Web.UI.Page

{

privatevoid bindgrid()

{

string conStr ="Data Source=.;Initial Catalog=Northwind;Persist Security Info=True;User ID=sa";SqlConnection conn =newSqlConnection(conStr);// Open the connection

conn.Open();

// Create a data adapter objectSqlDataAdapter adapter =newSqlDataAdapter("SELECT * FROM testt", conn);DataSet ds =newDataSet();

adapter.Fill(ds);

GridView1.DataBind();

conn.Close();

}

protectedvoid Page_Load(object sender,EventArgs e)

{

if (!IsPostBack)

{

bindgrid();

}}}

///////////////////////////////

the body of aspx file is here:

<

body><formid="form1"runat="server"><div> <asp:SqlDataSourceID="SqlDataSource1"runat="server"></asp:SqlDataSource><asp:GridViewID="GridView1"runat="server"></asp:GridView></div></form>

</

body>

/////////////////////////////////////

|||

Hi,

hsharifi:

publicpartialclassado1 : System.Web.UI.Page

{

privatevoid bindgrid()

{

string conStr ="Data Source=.;Initial Catalog=Northwind;Persist Security Info=True;User ID=sa";

SqlConnection conn =newSqlConnection(conStr);

// Open the connection

conn.Open();

// Create a data adapter objectSqlDataAdapter adapter =newSqlDataAdapter("SELECT * FROM testt", conn);DataSet ds =newDataSet();

adapter.Fill(ds);

GridView1.DataBind();

conn.Close();

}

protectedvoid Page_Load(object sender,EventArgs e)

{

if (!IsPostBack)

{

bindgrid();

}}}

///////////////////////////////

the body of aspx file is here:

<

body><formid="form1"runat="server"><div> <asp:SqlDataSourceID="SqlDataSource1"runat="server"></asp:SqlDataSource><asp:GridViewID="GridView1"runat="server"></asp:GridView></div></form>

</

body>

/////////////////////////////////////

it seems like you're trying to do 2 things here: you want to use code & the SqlDataSource control together, that's a no go.

Get rid of the SqlDataSource control on your page and in the codefile, just before you call the DataBind() method place this line:

GridView1.DataSource = ds;
GridView1.DataBind();

Grz, Kris.

|||

Hi Xlll ,and thank you for replying me.

I did the thing that you said but my problem is still going on. After running my program the browser shows a blank page. I had to change many settings in IIS, do you think this problem is related to these changes or may be I should reinstall vs.net after that.

I would be glad to hear your opinion. Thanks

|||

Hi,

before re?nstalling you can first let the aspnet_regiis -i tool do its work to set the correct settings for the correct framework in IIS.

Something else that you can try: place a TextBox, Button and Label control on a webform. In the Button Click event you place this code:

Label1.Text = TextBox1.Text

and see if it executes well on your server. It's probably something stupid but I like to use such scenario's to quickly test out if ASP.NET is installed properly on a machine.

Grz, Kris.

Cant access table due to no owner (I think)

I can't access a number of tables on my SQL Server 7.0 database. Have checked using Enterprise Manager and the table does not appear to have any owner. When trying to do anything with the table I always get the following message

{SQL-DMO} The name 'Table Name' was not found in the tables collection. If the name is a qualified name, use [] to seperate various parts of the name, and the try again.

Have tried to change the owner by using sp_changeobjectowner but I am either getting the syntax wrong or it ain't working.

Any ideas??

c8lWhen you look in Enterprise Manager, what do you see?|||Hi,

The only thing I see is the table name (TABLE1), the type (USER) and the creation date. The owner column is blank. Normally you would expect it to say dbo.|||Blank?

What happends when you run this in QA?

SELECT * FROM INFORMATION_SCHEMA.Tables

Maybe you need to close EM and relaunch it. ...|||Thanks for the help but the problem has been resolved, I had to manually update the sysobject table so that the UID for each of the objects that could not be accessed was set to 1. For some reason this was 6.

Cheers
c8l

Can't access SqlServer 2005 using JDBC

Hi;

I can access SqlServer 2000 fine, but not SqlServer 2005. My client is on Windows XP and SqlServer 2005 (dev version) is on Windows 2003. When I run I get:

Error: net.windward.datasource.DataSourceException: JdbcDataSource could not ope
n jdbc:sqlserver://T1-Databases;databaseName=AdventureWorks;integratedSecurity=t
rue;
net.windward.datasource.DataSourceException: net.windward.datasource.DataSourceE
xception: JdbcDataSource could not open jdbc:sqlserver://T1-Databases;databaseNa
me=AdventureWorks;integratedSecurity=true;
at net.windward.datasource.jdbc.JdbcDataSource.<init>(JdbcDataSource.jav
a:1030)
at net.windward.xmlreport.RunReport.main(RunReport.java:165)
Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Invalid integratedSe
curity property value:true
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(U
nknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.connect(Unknown Sour
ce)
at com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at net.windward.datasource.jdbc.JdbcDataSource.<init>(JdbcDataSource.jav
a:1024)
... 1 more
Exception in thread "main" net.windward.datasource.DataSourceException: net.wind
ward.datasource.DataSourceException: JdbcDataSource could not open jdbc:sqlserve
r://T1-Databases;databaseName=AdventureWorks;integratedSecurity=true;
at net.windward.datasource.jdbc.JdbcDataSource.<init>(JdbcDataSource.jav
a:1030)
at net.windward.xmlreport.RunReport.main(RunReport.java:165)
Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Invalid integratedSe
curity property value:true
at
com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(U
nknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.connect(Unknown Sour
ce)
at com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at net.windward.datasource.jdbc.JdbcDataSource.<init>(JdbcDataSource.jav
a:1024)
... 1 more

Any ideas?

thanks - dave

Are you using Microsoft SQL Server 2005 JDBC Driver version 1.1?

What platform (OS and version) does your JDBC client run on?

|||

I have similar error:

java.lang.NoClassDefFoundError
at com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(Unknown Source)

I do have the JDBC driver version 1.1.

Cocoon 2.0

Tomcat 4.x

|||

Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Invalid integratedSe
curity property value:true

It appears as though it has something to do with integratedSecurity. I think the connection string is case sensitive, you did spell it IntegratedSecurity="True" right? The exception thrown seems to be targetted to integratedSecurity specifically. Also, are you authenticating in mixed mode or windows only? Did you configure the server on install correctly to be able to authenticate the kind of connection you are trying to make?

Hope we can figure this one out together,

John

|||

Have you tried enabling the TCP/IP Protocol through the SQL Server Configuration Manager? I seem to recall it being turned off by default in SQL 2005. Enable it and restart the SQL Service.

Good luck,

-Tom

|||You can run SQL Profiler to check if your application is indeed trying to establish a connection or not.|||It looks like you are using the 1.0 dirver which did not support integrated auth property.sql

Can't access SqlServer 2005 using JDBC

Hi;

I can access SqlServer 2000 fine, but not SqlServer 2005. My client is on Windows XP and SqlServer 2005 (dev version) is on Windows 2003. When I run I get:

Error: net.windward.datasource.DataSourceException: JdbcDataSource could not ope
n jdbc:sqlserver://T1-Databases;databaseName=AdventureWorks;integratedSecurity=t
rue;
net.windward.datasource.DataSourceException: net.windward.datasource.DataSourceE
xception: JdbcDataSource could not open jdbc:sqlserver://T1-Databases;databaseNa
me=AdventureWorks;integratedSecurity=true;
at net.windward.datasource.jdbc.JdbcDataSource.<init>(JdbcDataSource.jav
a:1030)
at net.windward.xmlreport.RunReport.main(RunReport.java:165)
Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Invalid integratedSe
curity property value:true
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(U
nknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.connect(Unknown Sour
ce)
at com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at net.windward.datasource.jdbc.JdbcDataSource.<init>(JdbcDataSource.jav
a:1024)
... 1 more
Exception in thread "main" net.windward.datasource.DataSourceException: net.wind
ward.datasource.DataSourceException: JdbcDataSource could not open jdbc:sqlserve
r://T1-Databases;databaseName=AdventureWorks;integratedSecurity=true;
at net.windward.datasource.jdbc.JdbcDataSource.<init>(JdbcDataSource.jav
a:1030)
at net.windward.xmlreport.RunReport.main(RunReport.java:165)
Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Invalid integratedSe
curity property value:true
at
com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(U
nknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.connect(Unknown Sour
ce)
at com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at net.windward.datasource.jdbc.JdbcDataSource.<init>(JdbcDataSource.jav
a:1024)
... 1 more

Any ideas?

thanks - dave

Are you using Microsoft SQL Server 2005 JDBC Driver version 1.1?

What platform (OS and version) does your JDBC client run on?

|||

I have similar error:

java.lang.NoClassDefFoundError
at com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(Unknown Source)

I do have the JDBC driver version 1.1.

Cocoon 2.0

Tomcat 4.x

|||

Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Invalid integratedSe
curity property value:true

It appears as though it has something to do with integratedSecurity. I think the connection string is case sensitive, you did spell it IntegratedSecurity="True" right? The exception thrown seems to be targetted to integratedSecurity specifically. Also, are you authenticating in mixed mode or windows only? Did you configure the server on install correctly to be able to authenticate the kind of connection you are trying to make?

Hope we can figure this one out together,

John

|||

Have you tried enabling the TCP/IP Protocol through the SQL Server Configuration Manager? I seem to recall it being turned off by default in SQL 2005. Enable it and restart the SQL Service.

Good luck,

-Tom

|||You can run SQL Profiler to check if your application is indeed trying to establish a connection or not.|||It looks like you are using the 1.0 dirver which did not support integrated auth property.

Can't access SqlServer 2005 using JDBC

Hi;

I can access SqlServer 2000 fine, but not SqlServer 2005. My client is on Windows XP and SqlServer 2005 (dev version) is on Windows 2003. When I run I get:

Error: net.windward.datasource.DataSourceException: JdbcDataSource could not ope
n jdbc:sqlserver://T1-Databases;databaseName=AdventureWorks;integratedSecurity=t
rue;
net.windward.datasource.DataSourceException: net.windward.datasource.DataSourceE
xception: JdbcDataSource could not open jdbc:sqlserver://T1-Databases;databaseNa
me=AdventureWorks;integratedSecurity=true;
at net.windward.datasource.jdbc.JdbcDataSource.<init>(JdbcDataSource.jav
a:1030)
at net.windward.xmlreport.RunReport.main(RunReport.java:165)
Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Invalid integratedSe
curity property value:true
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(U
nknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.connect(Unknown Sour
ce)
at com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at net.windward.datasource.jdbc.JdbcDataSource.<init>(JdbcDataSource.jav
a:1024)
... 1 more
Exception in thread "main" net.windward.datasource.DataSourceException: net.wind
ward.datasource.DataSourceException: JdbcDataSource could not open jdbc:sqlserve
r://T1-Databases;databaseName=AdventureWorks;integratedSecurity=true;
at net.windward.datasource.jdbc.JdbcDataSource.<init>(JdbcDataSource.jav
a:1030)
at net.windward.xmlreport.RunReport.main(RunReport.java:165)
Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Invalid integratedSe
curity property value:true
at
com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(U
nknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.connect(Unknown Sour
ce)
at com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at net.windward.datasource.jdbc.JdbcDataSource.<init>(JdbcDataSource.jav
a:1024)
... 1 more

Any ideas?

thanks - dave

Are you using Microsoft SQL Server 2005 JDBC Driver version 1.1?

What platform (OS and version) does your JDBC client run on?

|||

I have similar error:

java.lang.NoClassDefFoundError
at com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(Unknown Source)

I do have the JDBC driver version 1.1.

Cocoon 2.0

Tomcat 4.x

|||

Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Invalid integratedSe
curity property value:true

It appears as though it has something to do with integratedSecurity. I think the connection string is case sensitive, you did spell it IntegratedSecurity="True" right? The exception thrown seems to be targetted to integratedSecurity specifically. Also, are you authenticating in mixed mode or windows only? Did you configure the server on install correctly to be able to authenticate the kind of connection you are trying to make?

Hope we can figure this one out together,

John

|||

Have you tried enabling the TCP/IP Protocol through the SQL Server Configuration Manager? I seem to recall it being turned off by default in SQL 2005. Enable it and restart the SQL Service.

Good luck,

-Tom

|||You can run SQL Profiler to check if your application is indeed trying to establish a connection or not.|||It looks like you are using the 1.0 dirver which did not support integrated auth property.

Can't access SQL Server Reporting Services URL anymore

Hi all,
We've had a Reporting Services installation for nearly 6 months now with no
problems. Reporting Services is installed on a Windows 2003 machine which is
connecting to SQL Server 2000 databases.
This morning, it was reporting that the URL to access the report server
(http://server/reports) is returning the following error message:
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
'(null)'. Reason: Not associated with a trusted SQL Server connection.
Not sure where to go from here. Nothing has changed as far as we can tell.
Thanks,
JasonThere's also an error in the event log of the Reporting Services machine that
states:
Report Server cannot connect to the report server database.
How do I re-establish this connection? The database still resides on the
same server, same name as before. I am not sure how this happened.
"Jason" wrote:
> Hi all,
> We've had a Reporting Services installation for nearly 6 months now with no
> problems. Reporting Services is installed on a Windows 2003 machine which is
> connecting to SQL Server 2000 databases.
> This morning, it was reporting that the URL to access the report server
> (http://server/reports) is returning the following error message:
>
> 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
> '(null)'. Reason: Not associated with a trusted SQL Server connection.
>
> Not sure where to go from here. Nothing has changed as far as we can tell.
> Thanks,
> Jason
>

can't access SQL Server 2005 Cubes, when Integrity firewall runs

Hi,

i'm not able to access the content of the SQL Server Cubes, when i've running the Checkpoint Integrity firewall on the system. I've to shut down the firewall to see the content of the Cubes. Does any one have idea, what could cause this?

best regards

Alfredo

allow traffic to pass thru port 1433 for sql server clients|||

hi,

thx for your answer, traffic for is port 1433 is open. For testing i allowed also any traffic, but it didn't fix the issue, it only works when Integrty doesn't. I had a similar issue with the Ab Initio application, but this Software Company did fix the issue. I don't know how they exactly fixed it, but it was not a Firewall Policy related issue.

|||

kindly post the error text.

|||

Hi,

there are no error messages, the SQL server 2005 Managemnet Studio application just 'hangs', when the Integrity firewall runs. We've the issue, only when we try to accecss the content of the Cubes container, independent if we use the SQL Server toools or f/e Microsoft Excel to access it.

can't access SQL Server 2005 Cubes, when Integrity firewall runs

Hi,

i'm not able to access the content of the SQL Server Cubes, when i've running the Checkpoint Integrity firewall on the system. I've to shut down the firewall to see the content of the Cubes. Does any one have idea, what could cause this?

best regards

Alfredo

allow traffic to pass thru port 1433 for sql server clients|||

hi,

thx for your answer, traffic for is port 1433 is open. For testing i allowed also any traffic, but it didn't fix the issue, it only works when Integrty doesn't. I had a similar issue with the Ab Initio application, but this Software Company did fix the issue. I don't know how they exactly fixed it, but it was not a Firewall Policy related issue.

|||

kindly post the error text.

|||

Hi,

there are no error messages, the SQL server 2005 Managemnet Studio application just 'hangs', when the Integrity firewall runs. We've the issue, only when we try to accecss the content of the Cubes container, independent if we use the SQL Server toools or f/e Microsoft Excel to access it.

sql

Cant Access SQL Server (on Vista) from other Network PC (XP)

I have just installed Vista on one of my home network pcs. I also installed Outlook 2005 with Business Contact Manager. It installs an instance of SQL Server Express.

I have created another database on this engine that I need to access from other PCs on my network.

The server address is PCNAME\MSSMLBIZ and I can access the data the database using this name from the the Vista PC (PCNAME).

When I try to acess the database using the same credentials (server, database, username (sa) and password) from an XP PC on the network - it times out and returns an error . My guess is that it is not seeing the database service at all.

I have SQL Server Management Studio installed on the Vista PC and have full access to the instance.

Server authentication is set for SQL Server and Windows Authentication mode.

Can anyone help me?. I need to access the SQL Server from the XP PC.

Ian

Make sure that SQL Server Browser is running, you firewall is configured properly to allow the SQL Server traffic and that Remote connections are enabled for SQL Server. (See the screencats on my site for more information).

Firewall configuration: http://support.microsoft.com/default.aspx?scid=kb%3ben-us%3b914277


Jens K. Suessmeyer.

http://www.sqlserver2005.de

|||

Yes - that worked - as soon as I set remote access on Surface Area Configuration for Services and Connections page.

Regards Ian

|||I have just installed SQL Server 2005 Developer Edition on Windows Vista Ultimate, but i cant access and see "sql server managment studio" The only things i have are these >>>

Cant Access SQL Server (on Vista)

I have just installed Vista on one of my home network pcs. I also installed Outlook 2005 with Business Contact Manager. It installs an instance of SQL Server Express.

I have created another database on this engine that I need to access from other PCs on my network.

The server address is PCNAME\MSSMLBIZ and I can access the data the database using this name from the the Vista PC (PCNAME).

When I try to acess the database using the same credentials (server, database, username (sa) and password) from an XP PC on the network - it times out and returns an error . My guess is that it is not seeing the database service at all.

I have SQL Server Management Studio installed on the Vista PC and have full access to the instance.

Server authentication is set for SQL Server and Windows Authentication mode.

Can anyone help me?. I need to access the SQL Server from the XP PC.

Ian

Make sure that SQL Server Browser is running, you firewall is configured properly to allow the SQL Server traffic and that Remote connections are enabled for SQL Server. (See the screencats on my site for more information).

Firewall configuration: http://support.microsoft.com/default.aspx?scid=kb%3ben-us%3b914277


Jens K. Suessmeyer.

http://www.sqlserver2005.de

|||

Yes - that worked - as soon as I set remote access on Surface Area Configuration for Services and Connections page.

Regards Ian

|||I have just installed SQL Server 2005 Developer Edition on Windows Vista Ultimate, but i cant access and see "sql server managment studio" The only things i have are these >>>

Can't Access SQL Server

Help! I've been hacked! I'm running SQL 7 Desktop (MSDE) and started getting
these messages at startup that servudaemon.exe was going to be shut down.
Then, at one point, I keep getting prompted by Norton Firewall that
serve-u.exe is trying to access the Internet. It suggested I deny it, which
I did; but I kept getting prompted every minute or so, so finally I told
Norton Firewall to always deny it.
Then, some minutes later, I close an Access 2000 mdb file I had opened which
uses SQL Server as a back end (through linked tables), and I was told that
connection to SQL Server had been lost. I tried reconnecting, but couldn't.
So I went into Enterprise Manager, and was told: "A connection could not be
established to D23 - Login failed for user 'sa'.."
So I went into Registration Properties, and saw that there was a password
there. I previously didn't have a password for 'sa' (which I know is stupid,
and now see the result of it). But there's a password now, and I can't
change it. So whatever hacked into my system set my 'sa' password.
Just to be sure that my settings in Norton Firewall weren't affecting
anything, I disconnected from the Internet and then disabled Norton Personal
Firewall. The results were the same.
So is there any way to restore my system?
Thanks for any assistance.
Neilserve-u.exe is possible ServeU, which is a popular FTP program. It seems
that you may have been hacked, and someone has configured an FTP site on
your machine (eg for serving mp3s, or warez or similar)
If you are a local administrator on the SQL Server machine, you should still
be able to login to SQL Server (using your Windows admin account, not the
"sa" account). You could reset the "sa" password then.
That said, you need to work out how these people got into your machine in
the first place. Additionally, since you don't know what other "back doors"
they have installed which might let them back in again, I'd say your best
bet is to backup your data, and then setup the machine from scratch.
Cheers
Ken
"Neil Ginsberg" <nrg@.nrgconsult.com> wrote in message
news:vfS4c.37319$aT1.26124@.newsread1.news.pas.earthlink.net...
: Help! I've been hacked! I'm running SQL 7 Desktop (MSDE) and started
getting
: these messages at startup that servudaemon.exe was going to be shut down.
: Then, at one point, I keep getting prompted by Norton Firewall that
: serve-u.exe is trying to access the Internet. It suggested I deny it,
which
: I did; but I kept getting prompted every minute or so, so finally I told
: Norton Firewall to always deny it.
:
: Then, some minutes later, I close an Access 2000 mdb file I had opened
which
: uses SQL Server as a back end (through linked tables), and I was told that
: connection to SQL Server had been lost. I tried reconnecting, but
couldn't.
: So I went into Enterprise Manager, and was told: "A connection could not
be
: established to D23 - Login failed for user 'sa'.."
:
: So I went into Registration Properties, and saw that there was a password
: there. I previously didn't have a password for 'sa' (which I know is
stupid,
: and now see the result of it). But there's a password now, and I can't
: change it. So whatever hacked into my system set my 'sa' password.
:
: Just to be sure that my settings in Norton Firewall weren't affecting
: anything, I disconnected from the Internet and then disabled Norton
Personal
: Firewall. The results were the same.
:
: So is there any way to restore my system?
:
: Thanks for any assistance.
:
: Neil
:
:|||sp3A is designed to stop access to the IO Port that exposes MSDE (and SQL
Server) to the web.
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
"Ken Schaefer" <kenREMOVE@.THISadOpenStatic.com> wrote in message
news:%23Wam0XbCEHA.3132@.TK2MSFTNGP11.phx.gbl...
> serve-u.exe is possible ServeU, which is a popular FTP program. It seems
> that you may have been hacked, and someone has configured an FTP site on
> your machine (eg for serving mp3s, or warez or similar)
> If you are a local administrator on the SQL Server machine, you should
still
> be able to login to SQL Server (using your Windows admin account, not the
> "sa" account). You could reset the "sa" password then.
> That said, you need to work out how these people got into your machine in
> the first place. Additionally, since you don't know what other "back
doors"
> they have installed which might let them back in again, I'd say your best
> bet is to backup your data, and then setup the machine from scratch.
> Cheers
> Ken
> "Neil Ginsberg" <nrg@.nrgconsult.com> wrote in message
> news:vfS4c.37319$aT1.26124@.newsread1.news.pas.earthlink.net...
> : Help! I've been hacked! I'm running SQL 7 Desktop (MSDE) and started
> getting
> : these messages at startup that servudaemon.exe was going to be shut
down.
> : Then, at one point, I keep getting prompted by Norton Firewall that
> : serve-u.exe is trying to access the Internet. It suggested I deny it,
> which
> : I did; but I kept getting prompted every minute or so, so finally I told
> : Norton Firewall to always deny it.
> :
> : Then, some minutes later, I close an Access 2000 mdb file I had opened
> which
> : uses SQL Server as a back end (through linked tables), and I was told
that
> : connection to SQL Server had been lost. I tried reconnecting, but
> couldn't.
> : So I went into Enterprise Manager, and was told: "A connection could not
> be
> : established to D23 - Login failed for user 'sa'.."
> :
> : So I went into Registration Properties, and saw that there was a
password
> : there. I previously didn't have a password for 'sa' (which I know is
> stupid,
> : and now see the result of it). But there's a password now, and I can't
> : change it. So whatever hacked into my system set my 'sa' password.
> :
> : Just to be sure that my settings in Norton Firewall weren't affecting
> : anything, I disconnected from the Internet and then disabled Norton
> Personal
> : Firewall. The results were the same.
> :
> : So is there any way to restore my system?
> :
> : Thanks for any assistance.
> :
> : Neil
> :
> :
>|||Xref: TK2MSFTNGP08.phx.gbl microsoft.public.sqlserver.msde:13508 microsoft.p
ublic.sqlserver.security:19785 microsoft.public.sqlserver.connect:41876
I'm running SQL 7. Do you know if there's a similar sp for that?
Neil
"William (Bill) Vaughn" <billvaRemoveThis@.nwlink.com> wrote in message
news:%23RoIB3fCEHA.1544@.TK2MSFTNGP09.phx.gbl...
> sp3A is designed to stop access to the IO Port that exposes MSDE (and SQL
> Server) to the web.
> --
> ____________________________________
> William (Bill) Vaughn
> Author, Mentor, Consultant
> Microsoft MVP
> www.betav.com
> Please reply only to the newsgroup so that others can benefit.
> This posting is provided "AS IS" with no warranties, and confers no
rights.
> __________________________________
> "Ken Schaefer" <kenREMOVE@.THISadOpenStatic.com> wrote in message
> news:%23Wam0XbCEHA.3132@.TK2MSFTNGP11.phx.gbl...
> still
the
in
> doors"
best
> down.
told
> that
not
> password
>

Cant access sql express stored procedure..help!

Hi everyone, im having alot of trouble trying to execute a stored proc from sql express. heres my code

DbProviderFactory db =DbProviderFactories.GetFactory("System.Data.SqlClient");

using(DbConnection conn = db.CreateConnection()){

ConnectionStringSettings s =ConfigurationManager.ConnectionStrings["constrolservicetest"];

conn.ConnectionString = s.ConnectionString;

conn.Open();

DbCommand cmd = conn.CreateCommand();

cmd.CommandText ="StoredProcedure1";

cmd.CommandType =CommandType.StoredProcedure;

DbParameter param = db.CreateParameter();

param.ParameterName ="@.test";

param.Value = 2;

cmd.Parameters.Add(param);

cmd.ExecuteNonQuery();

}

****************************procedure code***************************

Create PROCEDUREdbo.StoredProcedure1

(

@.testint

)

AS

Update temp

Settest = @.test

******************************************************************

The code just doesn't update. I know my connection string is correct because i got the datareader to work, but i just cant get the stored proc to call. Any help will be greatly appreciated.

Thanks,

-D

That code looks reasonable to me. Are you sure it's being called?

Can't access SQL Express from SQL Server

I installed SQL Express on an instance of Microsoft Virtual Server. I
haven't been able to connect to it from SQL Server which is running on the
same network, but on our real server. Now I have been able to successfully
able to connect to the real SQL Server from the Express but it doesn't work
the other way around. I am using the same hostname that I see in the
Express managment studio... \\PARENTVM\SQLEXPRESS using the login I created
in Express.
I allowed access through Windows Firewall, and I enabled the allow access
from remote users in the Express configuration.
What am I missing?
Hi there,
Have you enabled remote connections on the SQLExpress instance?
By default the remote connections are disabled. Open "SQL Server
Surface Area Configuration" under Configuration tools. You then need to
select the "Surface Area Configuration for Services and Connections"
option. The Remote connections option will allow you to change the
connection types. Once you've done that restart the service to make
sure the change takes effect.
Hope this help...
sql

can't access server from another PC

I recently reformatted my XP laptop and reinstalled SQL Server. Since I did
that I have been unable to access the SQL Server on my laptop from another
PC. When I go to register it from another PC I get:
"A connection could not be established to NAME-LAPTOP\NAME_LAPTOP.
Reason: SQL Server does not exist or access denied.
ConnectionOpen(Connect())"
The database is indeed running so I assume it must be some type of
permission problem. Both PCs are in the same domain. I have tried to connect
using Windows account information and SQL Server login information - both
get the same error. I also tried to connect from another PC to the laptop
with the same error. The laptop can see and access databases on each of
these other PC's so it is just reading from the laptop that is not possible.
I did disable my Norton Internet Security to make sure that the firewall
wasn't interferring but still get the same error.
I'm pulling my hair out and could really use your help. Thanks for taking
the time to read this.
InNeedOfAssistance wrote:
>I recently reformatted my XP laptop and reinstalled SQL Server. Since I did
>that I have been unable to access the SQL Server on my laptop from another
>PC. When I go to register it from another PC I get:
>"A connection could not be established to NAME-LAPTOP\NAME_LAPTOP.
>Reason: SQL Server does not exist or access denied.
>ConnectionOpen(Connect())"
>The database is indeed running so I assume it must be some type of
>permission problem. Both PCs are in the same domain. I have tried to connect
>using Windows account information and SQL Server login information - both
>get the same error. I also tried to connect from another PC to the laptop
>with the same error. The laptop can see and access databases on each of
>these other PC's so it is just reading from the laptop that is not possible.
>I did disable my Norton Internet Security to make sure that the firewall
>wasn't interferring but still get the same error.
>I'm pulling my hair out and could really use your help. Thanks for taking
>the time to read this.
Are you trying to login via Windows Authentication ? as the error message
seems that this login does not exist in the Security Logins. Do you have an
SQL Server ID you can just prove its Windows Auth with by logging in via that?
Alternatively I have had the problem with OS's where it uses Netpipes by
default which are blocked by the network, to prove this create an ODBC with
IP /Port to the SQL Server and prove this works.
Message posted via http://www.droptable.com
|||InNeedOfAssistance wrote:
>I recently reformatted my XP laptop and reinstalled SQL Server. Since I did
>that I have been unable to access the SQL Server on my laptop from another
>PC. When I go to register it from another PC I get:
>"A connection could not be established to NAME-LAPTOP\NAME_LAPTOP.
>Reason: SQL Server does not exist or access denied.
>ConnectionOpen(Connect())"
>The database is indeed running so I assume it must be some type of
>permission problem. Both PCs are in the same domain. I have tried to connect
>using Windows account information and SQL Server login information - both
>get the same error. I also tried to connect from another PC to the laptop
>with the same error. The laptop can see and access databases on each of
>these other PC's so it is just reading from the laptop that is not possible.
>I did disable my Norton Internet Security to make sure that the firewall
>wasn't interferring but still get the same error.
>I'm pulling my hair out and could really use your help. Thanks for taking
>the time to read this.
Are you trying to login via Windows Authentication ? as the error message
seems that this login does not exist in the Security Logins. Do you have an
SQL Server ID you can just prove its Windows Auth with by logging in via that?
Alternatively I have had the problem with OS's where it uses Netpipes by
default which are blocked by the network, to prove this create an ODBC with
IP /Port to the SQL Server and prove this works.
Message posted via droptable.com
http://www.droptable.com/Uwe/Forums.aspx/sql-server/200704/1
|||> Are you trying to login via Windows Authentication ? as the error message
> seems that this login does not exist in the Security Logins. Do you have
> an
> SQL Server ID you can just prove its Windows Auth with by logging in via
> that?
I tried to login with the sa account when I used SQL Server login
information and a login that I know is valid on my laptop for the Windows
account information login.
Probably another important piece of information that I didn't mention is
that when trying to register this database from another PC, it never is
displayed as one of the available databases. There is a NAME-LAPTOP database
that shows as available (I assume the default from installing Visual Studio)
but no NAME-LAPTOP\NAME_LAPTOP database as this one is called. I was
wondering if it might help to uninstall and reinstall SQL Server. Do you
know if there are ever any conflict between the Visual Studio db and the
main SQL Server db depending on install order? At this point, I don't
remember which I installed first. At one point, I had installed the Visual
InterDev on the laptop by accident but deleted that and installed Visual
Studio. I don't know if that could have messed anything up or not too.
Using Visual Studio on the laptop I can connect to the
NAME-LAPTOP\NAME_LAPTOP database but if I go to another PC I can't connect
using Visual Studio.

> Alternatively I have had the problem with OS's where it uses Netpipes by
> default which are blocked by the network, to prove this create an ODBC
> with
> IP /Port to the SQL Server and prove this works.
Do you mean create a script to see if I can login that way?.

> --
> Message posted via http://www.droptable.com
>
|||Just to let you all know - the uninstall and reinstall of the database on my
laptop fixed all my problems. I'm sorry I didn't try that from the
beginning.