# FS sql aND sql SERVER 2008 r2

**URL:** <https://forum.inductiveautomation.com/t/fs-sql-and-sql-server-2008-r2/6384>\
**Category:** Archived Topics\
**Created:** [May 5, 2013, 6:58am UTC](https://forum.inductiveautomation.com/t/fs-sql-and-sql-server-2008-r2/6384 "2013-05-05T06:58:00Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![talhajee1](https://avatars.discourse-cdn.com/v4/letter/t/7c8e57/32.png) [@talhajee1](https://forum.inductiveautomation.com/u/talhajee1)\
**Post date:** [May 5, 2013, 6:58am UTC](https://forum.inductiveautomation.com/t/fs-sql-and-sql-server-2008-r2/6384/1 "2013-05-05T06:58:00Z")

</div>

hI,  
I want to know how can i access sql server 2008 r2 from factory SQL with SQL server authentication .

I have created a new database for test purpose.  
I created a standard group and in database settings i have given credentials of user “t1” . Now when i run that group it has created table with user dbo not t1

so i want to know is it default behaviour or i am missing something.

Regards,  
Talha

PS: i am migrating from sql 2000 to 2008 r2 and i am unable to acess store procedures created with user “t1” so for test purpose i have done above mentioned steps but it makes me more confuse.