project deployment issues

Im having some issues when deploying my project written in vb.net which
uses and Sql server database. During development I used my local
machine as the server database, and this worked fine for myself and
other users on remote pcs.
But now I have changed the sql connection string to point to a
dedicated sql server for deployment of the completed project I am the
only user who can access it. I have another administrator with access
to the same database and he can view/edit all the tables in sql server
Enterprise Manager, but when he runs my program it generates an error
on the first attempt the program makes to retreive data from the
database.
It is a basic select statement which works fine for me, but generates a
"cannot find <table_name>" type of error. We are both using exactly the
same version of the project, so I know the table exists.
I thought it must be some kind of permission i need to set in the
database, but he seems to think because he can see it in enterprise
manager it must be in my code.Hi
Does "administrator" have a full access to the server ? Is he a memeber of
symin server role?
Who is an owner of the table?
How do you perform a SELECT statement?
SELECT <> FROM dbo.TableName
SELECT <> FROM fred.Tablename ( fred is an user and owner of the table)
<nathan.atkins@.alcoa.com.au> wrote in message
news:1139196815.500065.315700@.o13g2000cwo.googlegroups.com...
> Im having some issues when deploying my project written in vb.net which
> uses and Sql server database. During development I used my local
> machine as the server database, and this worked fine for myself and
> other users on remote pcs.
> But now I have changed the sql connection string to point to a
> dedicated sql server for deployment of the completed project I am the
> only user who can access it. I have another administrator with access
> to the same database and he can view/edit all the tables in sql server
> Enterprise Manager, but when he runs my program it generates an error
> on the first attempt the program makes to retreive data from the
> database.
> It is a basic select statement which works fine for me, but generates a
> "cannot find <table_name>" type of error. We are both using exactly the
> same version of the project, so I know the table exists.
> I thought it must be some kind of permission i need to set in the
> database, but he seems to think because he can see it in enterprise
> manager it must be in my code.
>|||
> Does "administrator" have a full access to the server ? Is he a memeber of
> symin server role? - Yes

> Who is an owner of the table? - Me
> How do you perform a SELECT statement?
>
> SELECT <> FROM dbo.TableName
> SELECT <> FROM fred.Tablename ( fred is an user and owner of the table)
Currently im saying "SELECT <> FROM tablename
After reading your post im starting to think this is the problem, but
how to fix i dont know.|||Nathan --
Look in Enterprise Manager under "tables" on the database. Who is the
owner of the table you want to access? Is it "dbo" or is it you? Try
"select * from dbo.<table_name>" or "select * from
[DOMAIN\yourlogin].<table_name>. Does the latter one work? If so, you
are probably going to want to recreate your tables with "dbo" as the
owner, instead of yourself:
CREATE TABLE dbo.NewTable (...)
vs
CREATE TABLE NewTable
My best guess--
-Dave Markle
nathan.atkins@.alcoa.com.au wrote:
> Im having some issues when deploying my project written in vb.net which
> uses and Sql server database. During development I used my local
> machine as the server database, and this worked fine for myself and
> other users on remote pcs.
> But now I have changed the sql connection string to point to a
> dedicated sql server for deployment of the completed project I am the
> only user who can access it. I have another administrator with access
> to the same database and he can view/edit all the tables in sql server
> Enterprise Manager, but when he runs my program it generates an error
> on the first attempt the program makes to retreive data from the
> database.
> It is a basic select statement which works fine for me, but generates a
> "cannot find <table_name>" type of error. We are both using exactly the
> same version of the project, so I know the table exists.
> I thought it must be some kind of permission i need to set in the
> database, but he seems to think because he can see it in enterprise
> manager it must be in my code.
>