<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
> sysadmin 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)

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.