i got an error when retriving schema "db_accessadmin" the SQL Server 2005 in the Virtual PC, the windows firewall of virtual was closed. and the sql server enabled remote connection (both using TCP/IP and named pipes)

error: dbnetlib connectionopen invalid instance . invalid connection

Details: -----[Core exception]-------------------- at System.Data.OleDb.OleDbConnectionInternal..ctor(OleDbConnectionString constr, OleDbConnection connection) at System.Data.OleDb.OleDbConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningObject) at System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup) at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) at System.Data.OleDb.OleDbConnection.Open() at SD.LLBLGen.Pro.DBDrivers.SqlServer.SqlServerSchemaRetriever.RetrieveSchema(String connectionString, IDBSchema schemaToRetrieve, SchemaFetchFlags fetchFlags) at SD.LLBLGen.Pro.DBDrivers.SqlServer.SqlServerCatalogRetriever.RetrieveSchemas(String connectionString, IDBCatalog catalogToRetrieve, SchemaFetchFlags fetchFlags) at SD.LLBLGen.Pro.DBDrivers.SqlServer.SqlServerDBDriver.PopulateSelectedCatalogs(Hashtable callBacks, Hashtable connectionElements, SchemaFetchFlags fetchFlags, Hashtable properties) at bf.d()

any ideas will be appreciated.

Daniel

• LLBLGen version?
• What server name are you setting in Designer (if possible make it a hard IP / instancename)?
• Please double check that the ports 1433 and 1434 are open in your firewall.

LLBLGen version:2.6 Demo the server name is hard ip address : 192.168.200.10

virtual pc firewall was closed

current pc : i can use sql server stuido management connect to that sql server the port: 1433,1434 are opened

but my UAC (win7) was closed

i will open my UAC and reinstalled my LLBLGen again.

Thank you

i cannot upload screenshot

but after i entered server name ,username ,password of sql server, and then click button "connect" ,it's working fine ,and got all databases and shown as list in the catalogs section

then i selected database "Northwind" , and click "Create" button

then the window "Progress" was shown

and the message is :

General task: Retriving schema "db_accessadmin"

sub task

then i got an error that described as before.

sovled

after i opened UAC and re-installed LLBLGen

and we need to use Administrator for run LLBLGen

Thanks

nevernet wrote:

sovled

after i opened UAC and re-installed LLBLGen

and we need to use Administrator for run LLBLGen

Thanks

You don't necessarily need admin rights to run it, but if you use windows-level security on sqlserver, you indeed need it. You could also use db level security (e.g. the 'sa' account or similar'.

Otis wrote:

nevernet wrote:

sovled

after i opened UAC and re-installed LLBLGen

and we need to use Administrator for run LLBLGen

Thanks

You don't necessarily need admin rights to run it, but if you use windows-level security on sqlserver, you indeed need it. You could also use db level security (e.g. the 'sa' account or similar'.

actually , my sql server account is "sa" superuser.

although i dont know where was wrong ,but after i run LLBLGen under Administrator, it's working now.

what's mean of "use windows-level security on sqlserver"?

Thank you

what's mean of "use windows-level security on sqlserver"?

You can access SQL Server using a database account (e.g. sa) Or by using a Windows Account (Windows Authentication).

Walaa wrote:

what's mean of "use windows-level security on sqlserver"?

You can access SQL Server using a database account (e.g. sa) Or by using a Windows Account (Windows Authentication).

"sa" account by using sql server studio management and also i can connect to sql server by using Windows Account (Windows Authentication) by using sql server studio management

in other words ,i can connect to sql server by using sql server studio management anyway.

The question was which of these do you use to connect through LLBLGen Pro Designer?

Walaa wrote:

The question was which of these do you use to connect through LLBLGen Pro Designer?

sorry, actually ,i am not sure i understand your mean exactly.

i used to connect through LLBLGen pro designer.

but if i cannot run LLBLGen under administrator , i cannot connect to sql server through LLBLGen.

I am running into the same problem and this was working not to long ago (the team lead ran a knowledge transfer with me logged into the dev system and refreshing the catalog). I am at a loss as to what else to check.

I was not the original developer and that person has left so I was wondering if the lgp file has his name in it and that his user account has been deleted so there is an issue there.

The installation was on a shared dev box and appears to just come from a zip file. The version is LLBLGen Pro v2.6.

I can retrieve the catalogs but the failure is on the schema retrieval.

1433 and 1434 ports are opened for the 64 bit SQL Server 2008 R2. I have tried from different machines and I am using the db login credentials .

Any suggestions or logging that I could look at would be helpful thanks.

Hi floater,

floater wrote:

I was not the original developer and that person has left so I was wondering if the lgp file has his name in it and that his user account has been deleted so there is an issue there.

Likely. You have to check how are you logging into the server when using LLBLGen 'Refresh Catalog' wizard. The best option is that you log in with a superuser (sa) so LLBLGen can run the catalog queries to retrieve the metadata.

(btw, please next time open a new thread instead of re-open old ones. Thanks).

you should fill port number when you connect to sql server by using LLBLGen designer.

floater wrote:

I am running into the same problem and this was working not to long ago (the team lead ran a knowledge transfer with me logged into the dev system and refreshing the catalog). I am at a loss as to what else to check.

I was not the original developer and that person has left so I was wondering if the lgp file has his name in it and that his user account has been deleted so there is an issue there.

The installation was on a shared dev box and appears to just come from a zip file. The version is LLBLGen Pro v2.6.

I can retrieve the catalogs but the failure is on the schema retrieval.

1433 and 1434 ports are opened for the 64 bit SQL Server 2008 R2. I have tried from different machines and I am using the db login credentials .

Any suggestions or logging that I could look at would be helpful thanks.