This question is locked. New answers and comments are not allowed.
I am trying to create an OpenAccess Data model connecting to my SQL Azure database using the new domain model wizard
ORM- latest free version.
I am getting a login error
I can create a sql data source connecting to the azure db fine and can connect to it fine via management studio
The connection string sql azure management web site gave me is:
Server=tcp:MYDATABASE.database.windows.net,1433;Database=[MYDBNAME];User ID=XXX@XXXXXX;Password=MyPassword;Trusted_Connection=False;Encrypt=True;Connection Timeout=30;
I selected Microsoft SQl Azure as the backend in the open access wizard
I get this error:
Unable to retrieve database schema information.
Reason: Cannot open database "[XXXX]" requested by the login. The login failed.
Login failed for user 'XXXX'.
The session has been assigned a tracking ID blah blah blah...
I think my connect string is correct.
From the Telerik documentation:
(http://www.telerik.com/help/openaccess-orm/getting-started-root-quickstart-azure-connect-through-ssms.html)
In the Connection String field enter the following connection string.
Server=tcp:server_name.database.windows.net;Database=SofiaCarRental;User ID=user_name@server_name;Password=myPassword;Trusted_Connection=False;Encrypt=True;
You should specify the following parameters in the connection string:
-server_name - the name of your assigned server.
-user_name - this is a valid logon user granted to use the SofiaCarRental. By default you could use the database master.
-myPassword - your password.
ORM- latest free version.
I am getting a login error
I can create a sql data source connecting to the azure db fine and can connect to it fine via management studio
The connection string sql azure management web site gave me is:
Server=tcp:MYDATABASE.database.windows.net,1433;Database=[MYDBNAME];User ID=XXX@XXXXXX;Password=MyPassword;Trusted_Connection=False;Encrypt=True;Connection Timeout=30;
I selected Microsoft SQl Azure as the backend in the open access wizard
I get this error:
Unable to retrieve database schema information.
Reason: Cannot open database "[XXXX]" requested by the login. The login failed.
Login failed for user 'XXXX'.
The session has been assigned a tracking ID blah blah blah...
I think my connect string is correct.
From the Telerik documentation:
(http://www.telerik.com/help/openaccess-orm/getting-started-root-quickstart-azure-connect-through-ssms.html)
In the Connection String field enter the following connection string.
Server=tcp:server_name.database.windows.net;Database=SofiaCarRental;User ID=user_name@server_name;Password=myPassword;Trusted_Connection=False;Encrypt=True;
You should specify the following parameters in the connection string:
-server_name - the name of your assigned server.
-user_name - this is a valid logon user granted to use the SofiaCarRental. By default you could use the database master.
-myPassword - your password.